Visualize data with different hierarchy/level in Matrix visual(in other visuals as well)
When visualizing data which has different hierarchy levels in Matrix table(in other visuals as well like tree map and so on), it is showing expand(+) even there is no data for that hierarchy/level.
For example, Some data has 3-level hierarchy(full hierarchy, the first and second rows), while some other has only 2-level hierarchy( like below third row does not have any data for hierarchy3
hiearchy1 hiearchy2 hiearchy3
aaa bbb ccc
aaa ddd eee
aaa fff
When you visualize above table in matrix there expand (+) is enabled in hierarchy2 of "fff" even there is no data after it in hierarchy3.
Idea:
Would be nice if Power bi can evaluate above data structure and do not display expand(+) in Matrix visual, if there is no data in next hierarchy or the same data.
1 Comment
- fbcideas_migusrNew MemberStatus added:New
Recent ideas
SQL Analytics Endpoint host name - CNAME or defined alias
The host name for a SQL Analytics endpoint is ugly. They look like this: random_ugly_alphanumeric-random_ugly_alphanumeric.datawarehouse.fabric.microsoft.com The first segment looks like it...Mike_Diehl24 minutes agoNew MemberNew27Views2likes1CommentFix links generated in multi tenant setups
When I log into Fabric, and I have access to multiple tenants, the links generated for things like monitoring URLs in pipeline runs do not include "ctid=<tenantguid>" query string value, which appear...jwisemanfs3 hours agoNew MemberNew3Views0likes0Comments