Forum Discussion
Resolver IIHiding specific measures in a matrix
Hello! I am hoping you smart people can assist. I would like to hide measures in a matrix, but only for some of my categories.
I have a matrix with categories (OGroup) and under each I have several measures. In the screenshots attached, you can see the RED arrow rows have no data for that measure (and never will). How do I hide just that one measure for those two categories? Every time I try to exclude, it excludes the whole category. Or what if I want to hide certain measure just in the totals, PURPLE arrow examples? PBIX link is here: https://drive.google.com/file/d/1bZ6068YYDy9PzZXmDSdE2yloIsPhdO90/view?usp=sharing
Screenshots are here: https://drive.google.com/file/d/1ZZ4DHCJm8olnbx4VXvyorNkHQR93W-tw/view?usp=sharing
https://drive.google.com/file/d/1fd4i8VkWeRjaL6gHBzMdQ7WxL-b0F4in/view?usp=sharing
matrix, @hidemeasure
dkernen Unfortunately you can't hide it just for one category - you might be able to try conditionally formatting it so if value is blank heading is white, but you'll still see the gap for the row....
HI dkernen,
I'd like to suggest you create a calculated table for all measure names then you can use the switch function to show different results based on the current category.
My Favorite DAX Feature: SELECTEDVALUE with SWITCH
After these steps, you can add some 'if statements' to handle particular category values and return blank results.
Regards,
Xiaoxin Sheng
3 Replies
- AllisonKennedy
Community Champion
dkernen Unfortunately you can't hide it just for one category - you might be able to try conditionally formatting it so if value is blank heading is white, but you'll still see the gap for the row....
HI dkernen,
I'd like to suggest you create a calculated table for all measure names then you can use the switch function to show different results based on the current category.
My Favorite DAX Feature: SELECTEDVALUE with SWITCH
After these steps, you can add some 'if statements' to handle particular category values and return blank results.
Regards,
Xiaoxin Sheng
dkernenInteresting. Thank you for the innovative solution!