Forum Discussion
Gauge not filtering the table visual?
Hi All,
I have a gauge chart and a table visual in my power bi report. My goal is for the table to be filtered when the gauge is selected. Currently, that is not happening. Any idea why?
For eg, I have 3 different gauges for 3 different departments. When I click on gauge A, then I want the table to show records only for department A. Is it possible?
Hi MFelix , Anonymous ,
Thanks a lot for your inputs. I tried Felix's method, but couldn't get the visual to be transparent. However, I found another article from Power BI community that has solved my problem. I am sharing it here in case others want to try,
https://powerdax.com/using-card-slicer-power-bi/
Thanks again, Happy New Year 2022!!!!
4 Replies
- MFelix
Super User
Hi Anonymous ,
Using the gauge chart this is not possible since the gauge is a single value that cannot be used to interact with other visualization on a point and click.
This is visible when you select the Edit Interactions and you can see that the other visualizations have no option selected:
In this case the option can be to add another visual on top of it with transparent colors to do the job.
I explain this techique on my blog post below (it's in portuguese but google translate works prety well)
Hi Anonymous ,
Agree with MFelix .Interactions are not available for gauge chart since there is a single value in it. You could follow his suggestion to replace gauge with other visuals which could use "Edit Interaction" feature.
Or you could use slicer or create bookmarks.
1. Add a slicer:
2. Create bookmarks:
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Hi MFelix , Anonymous ,
Thanks a lot for your inputs. I tried Felix's method, but couldn't get the visual to be transparent. However, I found another article from Power BI community that has solved my problem. I am sharing it here in case others want to try,
https://powerdax.com/using-card-slicer-power-bi/
Thanks again, Happy New Year 2022!!!!
- MFelix
Hi Anonymous ,
Just for additional information the transparent color is achieve by adding the metric below and making a condittional formatting:
Color = "#00000000"
