Forum Discussion
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...
Hi,
We would like to gauge instaed of card. Can you help us with steps to hide data in gauge visual using DAX.
parry2k
Super User
Super UserAnonymous 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!
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
Most Valuable Professional
Hi Anonymous ,
can you share a sample PBIX?
