Forum Discussion
Suppressing Values in Matrix Visual
Hello, I am trying to apply a filter to a matrix visual that'll allow me to hide values if the employee count for a department on a date is equal to 1. We want to suppress the values that are 1 to...
Anonymous , Create a measure first using
Employee Count = SUM('Employee Table'[Count])
Show/Hide Employee Count =
IF(
[Employee Count] = 1,
BLANK(),
[Employee Count]
)
Use the Show/Hide Employee Count measure in your matrix visual instead of the original employee count. This measure will display the employee count only if it is not equal to 1, effectively hiding the values where the count is 1.
Hi Bhanu,
Thanks for the reply! I implemented your solution in the image below and it is not quite working as expected. The one employee in Department 1 is showing blank as expected, but in Department 4, there are two employees so it is ok to show the data for them. I'd like the value to be blank if there is only one employee total in the department on that date.