Forum Discussion
tom-lenzmeier
Helper II
Helper IIMatrix Showing Blank Values Based On Slicer
Hello, I have a matrix showing sales by sales rep, account manager, division manager, etc. I have a slicer that is filtering by customer. When I select a customer, the matrix is showing all of th...
Matrix is showing all reps because Power BI displays dimension members even if measure = 0/blank.
In your measure: return BLANK() instead of 0.
Disable "Show items with no data" on row fields.
Add visual-level filter: measure is not blank.
👉 Quickest: change measure to return BLANK() for no sales.
v-sdhruv
Community Support
Community SupportHi tom-lenzmeier ,
Just wanted to check if you got a chance to review the suggestions provided and whether that helped you resolve your query?
Thank You MasonMA and Shahid12523 for your valuable inputs.