Forum Discussion
Filter out all blank values except one specific row
Hello guys i have an employee payroll table
I have a visual table in dax that looks like this
Employee hours pay in local pay in usd
EmpA 100 0 200
EmpB 125 0 250
EmpC 1000
EmpD
So as you see empD is showing but i dont want him to show so i use the filter tab next to the visual and fields tab and filter out where hours is blank so empC and empD are goen now
But i want to make an exception for empC to show anyways what can i do?
Hi Anonymous ,
If your table looks like as below, I think EmpD will be hidden by default as tamerj1 mentioned.
You can try to turn off "Show items with no data" in columns field.
Or you can try to create a measure to filter your visual.
Measure = IF(SUM('Table'[hours])+SUM('Table'[pay in local])+SUM('Table'[pay in usd]) >0,1,0)Add this measure into visual level filter and set it show items when value = 1.
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
- tamerj1
Community Champion
Anonymous
Blank rows should not appear in the report by default. Please provide more context.Hi Anonymous ,
If your table looks like as below, I think EmpD will be hidden by default as tamerj1 mentioned.
You can try to turn off "Show items with no data" in columns field.
Or you can try to create a measure to filter your visual.
Measure = IF(SUM('Table'[hours])+SUM('Table'[pay in local])+SUM('Table'[pay in usd]) >0,1,0)Add this measure into visual level filter and set it show items when value = 1.
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
