Create visuals dynamically

andriikubrak · ‎11-08-2017

Hello,

Is there are any way to create visuals dynamically based on data? Let's say you have 10 rows in a table and you need to build 10 gauges that are filled with data from each row? Is there are any possibility or workaround?

v-jiascu-msft · ‎11-09-2017

Hi @andriikubrak,

It's possible. But it couldn't be a best solution for your scenario.

1. Add an index column in the Query Editor.

2. Add ten Gauges and set the visual level filter to [Index] = 1, 2...10.

Best Regards!

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous · ‎11-08-2017

Not in the way you have described. There is no macro system in Power BI that could produce visuals.

I have some Dynamic visuals in my reports. I have a selection table, which i link to a dropdown menu. When a user selects one, this informs my display Measure. The display measure checks the ID, using a MIN statement, and with a switch calls other Measures for the required results.

Whilst you may not use it exactly like that, you could take the idea and run with it. Have a set of measures that display different outputs depending on what is contained in your data. You would have to set up ahead of time what you Max number of visuals are.