Forum Discussion
How to hide some rows values in a Matrix
Hello everyone, Using PowerBI Desktop, I wonder If I can hide the values showing up in red area below : I want to keep the total of each CS Average theoretical_value_for_tr and Average of Ove...
Hi RomainBSNP
Create a measure like (Item is the column which holds data line ACTUAL_PICES ect)
Measure = VAR _Item = SELECTEDVALUE(Table[Item])
RETURN
IF(
_Item IN {"ACTUAL_PICES","----","----",so on},BLANK(),YourMeasure or Value COl)
Let me know if that works for you
If your requirement is solved, please mark THIS ANSWER as SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.
Thanks
Pijush
Linkedin