Hide a column if the SUM of the Values is 0

[Nikhil_567]

Hello Champs,

I am stuck in a situation where I have a scenerio like below-

Matrix Visual

In the above image it's a matrix visual, where I have passed Date in Column, Attribute in Rows, and a calculated measure in Values.

If you look at the first column, which is April 2024, the Total is 0, and as per the requirement, I need to hide whenever a sum of column shows 0.

Can you please advise how can I achieve this?

[v-cgao-msft · Accepted solution]

Hi @Nikhil_567 ,

Please create a new measure like:

Measure = 
VAR __row_total = CALCULATE([YourMeasure],ALLEXCEPT('Table','Table'[Column]))
VAR __result = IF(__row_total<>0,[YourMeasure],BLANK())
RETURN
__result

Output:

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum -- China Power BI User Group

[VijayP]

@Nikhil_567 

Create a Measure - 

CALCULATE(Measure in Values,FILTER('Table',[Measure in Values]<>0)) and use that in Values in Matrix