Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to Solution.
Hi @eliasayy ,
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.
@eliasayy
Blank rows should not appear in the report by default. Please provide more context.
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
Hi @eliasayy ,
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
42 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
39 | |
33 | |
18 | |
17 |