Hi all,
I have a table visual as below in PBI.
"specific loss prod WEC" is a DAX measure. "Service contract category" is a column from a"data table".
I would like to remove all zero values(highlighted) so that only non zero items are displayed . Kindly help
Hi,
I am not sure how your measure [specific loss prod WEC] is written, but please try to check if the result of each 0.00 is actually zero or not (for instance, 0.00032564). In this case, please try replacing a measure to the below.
new measure: =
IF (
ROUND ( [specific loss prod WEC], 2 ) == 0,
BLANK (),
[specific loss prod WEC]
)
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Schedule a short Teams meeting to discuss your question
Hi,
I am not sure how your measure [specific loss prod WEC] is written, but please try to check if the result of each 0.00 is actually zero or not (for instance, 0.00032564). In this case, please try replacing a measure to the below.
new measure: =
IF (
ROUND ( [specific loss prod WEC], 2 ) == 0,
BLANK (),
[specific loss prod WEC]
)
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Schedule a short Teams meeting to discuss your question
Helpful resources
Power BI Monthly Update - June 2025
Check out the June 2025 Power BI update to learn about new features.
Fabric Community Update - June 2025
Find out what's new and trending in the Fabric community.
