Dynamically add visual (gauge or kpi) per row of data

[jdubs]

I need to dynamically add a visual (gauge preferably) per row of data. I have a table of sales kpis that can vary, depending on the account. I want to display a visual for each row that exists, but this can vary per account. This was possible OOB with SSRS but I'm not finding a way to do this in Power BI.

[jdubs]

OK. Would I be able to hide a visual if no data exists for it?

[Sergii24]

Hi @jdubs, can you send a screenshot of what you want to achieve? As of my knowledge the only way to graphically represent data per row is using sparklines. You can learn more about here - link1 and link2.

[jdubs]

So this is the same SSRS report run on two different accounts using the same data source. In the 1st screenshot there are 5 rows of data, thus 5 gauges. In the second screenshot, there are only 2 rows of data, so only two gauges are displayed.

Account 1Account 2

[Sergii24]

I don't think that you can obtain a similar result in PowerBI... Number of gauges and what exactly is showed there should be defined in advance.