Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

undefined

Hi,

 

In power bi, if I do not select anything from the slicer, my KPI visualization should show blank, but it does not. It shows a value from the table. I do not need that value if I have not selected anything from the slicer.

Please could you help me with this.

 

Thanks.

Need Help

4 Replies

Replies have been turned off for this discussion
  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Anonymous,

    Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

    How to Get Your Question Answered Quickly  

    Regards,

    Xiaoxin Sheng

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hi Xiaoxin Sheng Anonymous,

      I have attached the images for your reference.

      This is the raw data structure which is being used for the visualization.

       

       

       

       

       

       

       

      If I do not select anything from the slicer, my KPI visualization should show blank, but it does not. It shows a value from the table. I do not need that value if I have not selected anything from the slicer.

      Please could you help me with this.

       

      Meliena

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        Hi Anonymous,

        I'd like to suggest you modify the expression that used on the KPI visual and add an if statement with ISFILTERED function to check if the field has been filtered, then you can use this function result as condition to skip the calculations.

        formula =
IF ( ISFILTERED ( Table[SilcerColumn] ), 'raw expression' )

        ISFILTERED function (DAX) - DAX | Microsoft Learn

        Regards,

        Xiaoxin Sheng