Gauge Click Filters Table

Question

I’m new in Power BI. I have a few gauge visuals on my page.

I want to give users the capability to see the records behind the kpi. Ideally, when the click on a gauge, they would be given an option to see the detail records. Right now, i have the gauges on my page and a table with the rows. If i click on a gauge, the table does not get filtered accordingly.

How do I do this?

anonymous · Answer

Hi&nbsp;Vdbpcl,&nbsp;An option in Power BI is&nbsp; to see the underlying data, if you select a certain visual (in your case a gauge) you can click on "See data" like showed in the attached pictures:&nbsp;Before clickin on "See data"After clicking "See data"Best regards,L.Meijdam

vdbpcl · Answer

Hi Anonymous,I saw the “See Data” option. But I am looking for the records/data. In your screenshot for example, I am looking to see the 7 rows for Shirt, not the count.V

v-huizhn-msft · Answer

Hi&nbsp;Vdbpcl,When you create a table visualization, let the table display all rows without summarizing your rows. When you click on the Gauge, you will see all records in the table.Best Regards,Angelia

vdbpcl · Answer

Hi&nbsp;v-huizhn-msft,&nbsp;The table visualization does not respond to the click on the Gauge.&nbsp;I wanted to share a screenshot of my page, but&nbsp;I have some data on it that I cannot share.---&nbsp;I have two gauges&nbsp;and a table visualization on the page.&nbsp;* The table visualization has raw data (no aggregation).* Gauge 1 shows the KPI (count) of a subset of the table visual. I have a visual filter of Key = 'g1'* Gauge 2 shows the KPI (count) of a different subset of the table visual. I have a visual filter of Key = 'g2'&nbsp;When I click Gauge 1, the table visualization should automatically be filtered by Key = 'g1'. Similar behavior should happen with Gauge 2 (i.e. table visual should be filtered by Key = 'g2'. However, right now, when I click on either of the gauges, the table visual is not filtering anything.&nbsp;&nbsp;

v-huizhn-msft · Answer

Hi&nbsp;Vdbpcl,The visual has fixed and been filter since use visual level filter, "when click Gauge 1, the table visualization should automatically be filtered by Key = 'g1'" How the operation happen? It's confusing.Best Regards,Angelia

Forum Discussion

Gauge Click Filters Table

7 Replies

Related content

Gauge Visual

Filter on Button Click

Click Graph to Filter

Dynamically Filtering with Gauges

Gauge losing target value upon filtering