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
Not found value "Available gateway clusters"
Hi, Currently the machine (A) hosting power BI on-prime gateway standard. Machine (B) also want to host this server with machine (A). Gateway on (A) and (B) is using the same tenant as admin user. I...Thas_Michael3 hours agoHelper INew3Views0likes0CommentsFabric Deployment Pipeline Should Automatically Preserve or Upgrade Semantic Model Compatibility
Category: Microsoft Fabric — Deployment Pipelines | Semantic Models | Direct Lake The Problem When deploying a Direct Lake semantic model containing calculated columns or calculated tables throug...Murtaza_Ghafoor5 hours agoSuper UserNew2Views0likes0CommentsNative Page-Level Security (PLS) or Dynamic Page Visibility based on RLS Roles
Description: Currently, Power BI provides robust Row-Level Security (RLS) to restrict data rows, but it lacks a native mechanism to restrict or hide entire report pages based on user roles or USERPRI...Erick1815 hours agoNew MemberNew3Views0likes0CommentsAdd standard ADBC search paths for ADBC drivers in Power BI
Considering the benefits of using ADBC drivers for data intensive operations, it would be nice to allow ADBC drivers to be used that are not necessarily packaged with Power BI installations. To mitig...hsadlier-pdx17 hours agoNew MemberNew5Views0likes0CommentsPower BI Subscriptions: Suppress OOO Replies and Improve Sender & Management Options
With the recent changes to Power BI subscription email delivery, Out of Office and other automatic replies can be returned to the individual subscription owner. For automated subscriptions sent to l...svcrowell18 hours agoNew MemberNew15Views2likes0Comments