Help to build a report using Gauge charts.

[kdesai]

Hi I am trying to build a report, where I can be able to change the number of gauges on a report dynamically!

My data-

I have a heirarchial site filter, where one site can have multiple providers associated with them.

Depending on the site and number of providers under that site, I want the page to have as many gauges dynamically.

i.e, If site1 has 10 providers I want 10 gauges with the actual vs budgeted visit for that provider.

and If  site2 has 6 providers I want 6 gauges with the actual vs budgeted visit and so on......

Let me know if I can dynamically change the number of gauges on the page.

[v-danhe-msft · Accepted solution]

Hi @kdesai,

It’s not supported to change visual visibility based on slicer selected values. You can create bookmarks to work around the issue.

You can refer to below sample:

1.I have entered some sample data and create two hierarchies to test for your problems like the picture below.

2.Create 7 Gauge visuals and use the “select pane” function and the “Bookmark” function to reserve the “A” site situation and the “B” site situation.

3.Create two blank buttons and set the action with “Bookmark”, link them to the related bookmark. Now you can change the number of gauges on a report dynamically by selecting the different buttons.

You can also download the PBIX file to have a view.

https://www.dropbox.com/s/c5iuixllpk7hibf/Help%20to%20build%20a%20report%20using%20Gauge%20charts..p...

Regards,

Daniel He

[v-danhe-msft · Accepted solution]

Hi @kdesai,

could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?

Regards,

Daniel He

[v-danhe-msft · Accepted solution]

Hi @kdesai,

It’s not supported to change visual visibility based on slicer selected values. You can create bookmarks to work around the issue.

You can refer to below sample:

1.I have entered some sample data and create two hierarchies to test for your problems like the picture below.

2.Create 7 Gauge visuals and use the “select pane” function and the “Bookmark” function to reserve the “A” site situation and the “B” site situation.

3.Create two blank buttons and set the action with “Bookmark”, link them to the related bookmark. Now you can change the number of gauges on a report dynamically by selecting the different buttons.

You can also download the PBIX file to have a view.

https://www.dropbox.com/s/c5iuixllpk7hibf/Help%20to%20build%20a%20report%20using%20Gauge%20charts..p...

Regards,

Daniel He