Forum Discussion
Automatic creation of visuals
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
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.
1 Reply
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.