Forum Discussion

Anonymous

Not applicable

4 years ago

Solved

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 20...

Anonymous
3 years ago
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 Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Icon for Community Champion rank

Community Champion

4 years ago

Anonymous
Blank rows should not appear in the report by default. Please provide more context.

Anonymous
Not applicable
4 years ago
ok so my table has payment per hour and transportation per day whixh are fixed this is why they will show when hours id blank
- Anonymous
  Not applicable
  3 years ago
  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 Zhou
  
  If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Related content