Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have a matrix with drill down option, for some categories there are 4 levels in the drill down where as for some others only 2 levels.
For the ones with only 2 levels , for eg in this case Write Off , i dont want blank to be displayed in 3rd and 4th level, how to do this?
Sample file attached:
https://drive.google.com/file/d/1GxPiajMP6seQSnRFa7eLVlJdm9Hvri8w/view?usp=sharing
Dont want these blank rows to appear
Solved! Go to Solution.
Hide Blank Level 3 & 4 = SWITCH ( TRUE (), ISINSCOPE ( Mapping[Sub Classification (Malls) 1] ) && ISBLANK ( SELECTEDVALUE ( Mapping[Sub Classification (Malls) 1] ) ), BLANK (), ISINSCOPE ( Mapping[Sub Classification 2] ) && ISBLANK ( SELECTEDVALUE ( Mapping[Sub Classification 2] ) ), BLANK (), SUM ( 'Table'[Column1] ) )
Hi @Antmkjr ,
According to your description, it is temporarily impossible to directly delete the blank lines on the third and fourth levels. If you delete empty rows through the "filter" function, the entire matrix visual will be affected.
I think the best way is to use the "+ -" button to not expand the rows that do not meet the conditions. The reference is as follows:
Hope to help you solve the problem.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Manually hide you mean?
Hi @Antmkjr ,
Yes, manually hide.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
No other way?>
Hi @Antmkjr ,
So far this is the best solution. If you have other ideas. You can post your idea here: Ideas - Microsoft Power BI Community
If there are a lot of votes, Microsoft will officially add this feature in the next update, hope it will help you.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hide Blank Level 3 & 4 = SWITCH ( TRUE (), ISINSCOPE ( Mapping[Sub Classification (Malls) 1] ) && ISBLANK ( SELECTEDVALUE ( Mapping[Sub Classification (Malls) 1] ) ), BLANK (), ISINSCOPE ( Mapping[Sub Classification 2] ) && ISBLANK ( SELECTEDVALUE ( Mapping[Sub Classification 2] ) ), BLANK (), SUM ( 'Table'[Column1] ) )
You should be able to deselect Blank in the Level 3 and 4 Visual Level Filters for that matrix in the Filters Panel.
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
When i deselect blank the entire category disappears, please find the attached sample file for ref.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
76 | |
73 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |