Automatic creation of visuals

dyna-adam — Fri, 10 Mar 2023 16:13:40 GMT

Hi,

Typically, while creating reports, I would lay out the format of my visuals in the report. Then I would filter the data being presented on those visuals using things like a drop-down menu or manually selecting the fields in the "filter" panel.

I wanted to know if it is possible to automatically create a new set of visuals if a new row is added to my dataset. For example, let's say I have a report that displays a graph and a set of KPIs for 3 rows in my dataset (shown in the screenshot below). Each set of visuals (graph and 3 KPIs) represents 1 row in my dataset. If an additional row is added to my dataset is it possible to automatically create these 4 visuals underneath the visuals that already exist in my report? Or do all visuals need to be manually placed beforehand? This functionality does not seem possible to me but I wanted to confirm. Thanks!

Example Report

Re: Automatic creation of visuals

giammariam — Sat, 11 Mar 2023 11:25:01 GMT

Hey @dyna-adam. The layout composition required for this can not be automatically generated natively in Power Bi. However, this could be done with a combination of faceting and concatenation in Deneb. If you're unfamiliar, there will be a learning curve, but your visualization options open up greatly with Deneb and the Vega languages.

If you are interested, and able to provide a .pbix with a current row of your visuals and a sanitized dataset (here's how), I can provide an implementation to show what's possible.

topic Re: Automatic creation of visuals in Custom Visuals Development Discussion

Automatic creation of visuals

Re: Automatic creation of visuals