Forum Discussion

ashmitp869's avatar
ashmitp869
Icon for Responsive Resident rankResponsive Resident
2 years ago
Solved

Don'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 :

 

Need Help

6 Replies

  • shafiz_p's avatar
    shafiz_p
    Icon for Super User rankSuper User
    2 years ago

    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's avatar
      Ronald123
      Icon for Resolver III rankResolver III
      2 years ago

      Hello @ashmitp869,

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



      Greets,

      Ronald



    • ashmitp869's avatar
      ashmitp869
      Icon for Responsive Resident rankResponsive Resident
      2 years ago

      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's avatar
        Irwan
        Icon for Super User rankSuper User
        2 years ago

        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.