Automatically add a new table to my power bi report once new line item is added to the table

[IM_1690]

Hi,

I want to automatically add a new table to my reports once new line item is added to the table.

Example- 

My Data looks like below 

Product	Value	Qty
A	1	10
B	3	20

Power Bi Should show tables like below 

Product	A
Value	1
Qty	10

Product	B
Value	3
Qty	20

later if a new product C is added power bi should automatically show the table for that.

Thanks 

[dm-p]

Hi @IM_1690,

It's not possible to add controls/visuals automatically based on dimension values and is a great scenario for small multiples but Power BI unfortunately doesn't support that.

I also think that your current approach will mean your use case won't scale particularly well. For example, the report canvas is set to a fixed height and will not scroll without manual intervention. I just did a quick test and with the default canvas size, I can add 6 and a half tables in this format and then I run out of room.

My suggestion - particularly if new product data is coming in - would be to use a matrix, with the fields set up as follows:

Then, in the Values menu set Show on Rows to On, which will place the measures underneath the product heading, e.g.:

Now, if a new product arrives in your dataset, this will be appended ito this layout, e.g.:

Keeping it within a single container also provides the ability for the user to scroll taller matrices if a lot of products start to accumulate.

If you absolutely must do it the way you want, then you'll need to look into developing a custom visual to do it, and If you're looking for someone to develop the visual for you, there are a number of consulting services on AppSource that you may be able to engage with.

I hope that you find some of this useful in solving your challenge. Good luck!

Daniel