Forum Discussion
ashmitp869
Responsive Resident
2 years agoDon't show the data when its zero in matrix visual
Hi All, How can I not show when the values are zero in matrix. So , the Date 4/07/2024 and 5/07/2024 should not be showing. Requirement is like below :
- 2 years ago
shafiz_p
Super User
2 years agoHi ashmitp869 Firstly I want you to update your power bi to the latest version, if not.
I have tried your provided file, opened a new page and place the same rows and columns accordingly and it worked for me.
I have found you relationship as below image:
This is the measure:
EmployeeHours =
SUM(DSR[DSRHours]) + SUM(Leave[Leave_Hours])
This is the output, which is you want.
This is the output, which is you want.
Suggesting you to create a new matrix visual.
Hope this helps!!
If this solved your problem, Please accept it as a solution!!
Best Regards,
Shahariar hafiz
Ronald123
Resolver III
2 years ago