Don't show the data when its zero in matrix visual

[ashmitp869]

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 :

[shafiz_p]

Hi @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.

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 · Accepted solution]

Hello @ashmitp869,

Deactivate "Show items with no data" in the column [Date].

Greets,

Ronald

[Irwan]

hello @ashmitp869 

how about visual filter?

Hope this will help.

Thank you.

[ashmitp869]

Hi ,

I have tried this but still showing.

The measure calculation is

EmployeeHours = CALCULATE(SUM(DSR[DSR_TimeSheet_Total_Hours]) + SUM(ConnXLeave[Leave_Hours]))

[Irwan]

hello @ashmitp869 

ah i see, that is a measure so forget about visual filter.

how about to put blank as result of zero sum?

Measure = 
var _Sum = SUM('Table'[Hours])
Return
IF(
    _Sum=0,
    BLANK(),
    _Sum
)

change _Sum formula to yours.

Hope this will help.
Thank you.

[ashmitp869]

Can you please me what I am doing wrong. I have added a sample file.

https://github.com/suvechha/samplepbi/blob/main/sample.pbix

I don't want to show the blank.