AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
Power Bi Filter Search3/31/2021
It provides robust functionalities such as Advanced Conditional Formatting, Multiple Reference Lines, Live Editing option to edit them on the fly.For example, you may want to focus on a product with gross margins under a certain range or below a certain threshold.This makes it easier to navigate large hierarchies as end users can visualize the areas(highlighted) which need their attention and chose their path to drill down.The different single child display options in the measure filter visual are as follows.
The child level is hidden in case it is the only child e.g. The Northeast region expands only till Boston thereby hiding the only child Suffolk. So, in case there more than 1 level having a consecutive single child then all the consecutive parents will be hidden, and the child moves up the level. Since the Northeast region has only one child at each level. The child node will move one level above in case it is a single child in the advanced hierarchy slicer. Since Suffolk has parent nodes having a single child, therefore the Northeast region ends directly into Suffolk and skips Massachusetts and Boston. You can assign different color, font style and size to visually pop out from the norm. The row settings can make sure that your rows are better spaced even when you have different font sizes for Top, Parent, and Child nodes. The value column setting width will allow enough space for the values from being cut off and optimum real estate for category labels. You can display additional context and information in the form of visualizations using the tooltip. In the below example, we can analyze Revenue for the Last 3, 6, and 12 months along with current and last month revenue comparison for each of the Price bands. This was you can get a complete picture of how each segment of your business is performing across the hierarchy. Headquartered in Plano, TX, Visual BI has a rich portfolio of unique BI products leveraged by 300 leading enterprises worldwide. Visual BI is a Microsoft Gold Partner for Data Analytics, and is also a partner to SAP, Snowflake, Fivetran, DBT, Tableau, Qlik, Alteryx and Looker. ![]()
0 Comments
Read More
Leave a Reply. |