Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

DAX function to hide Gauge visual by default

We are using the guage visual and the table visual in the powerBI report. Visual guage will show the health status of the machine. We have to search for the machine name in the visual search box (sma...
General Comment
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi,

 

We would like to gauge instaed of card. Can you help us with steps to hide data in gauge visual using DAX.

  • parry2k's avatar
    parry2k
    Super User
    6 years ago

    Anonymous whatever measure you are using on gauge change that measure as below

     

    Measure for gauge = 
IF ( HASONEFILTER ( Table[Machine] ), SUM ( Table[Column] ) )

     

    basically we are telling if no machine is selected/filtered then return blank value otherwise return value.

     

    I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi, thanks for reply but that did not worked. 

      We have score column and we have type column  (machine, RAM, CPU, etc..). We need to filter gauge visual using type(machine or RAM and CPU). Can you help on it.

       

       
       
      • mwegener's avatar
        mwegener
        Most Valuable Professional
        6 years ago

        Hi Anonymous ,

         

        can you share a sample PBIX?