Matrix visualisation which automatically adds new columns when new columns are added in database

[ruhi]

I have a database which looks like this and have created a matrix visualisation for the same in power BI.

Sno	Unit
1	Unit1
2	Unit2

After a few days, a new column gets added in my database and now it looks like this. Is it possible to automatically update the matrix visualisation so that it displays the new column also without the user having to select the new column from the side pane.

Sno	Unit	Block
1	Unit1	Block1

Please help.

[Icey · Accepted solution]

Hi @ruhi ,

It is not supported in Power BI.

But, there is one workaround when the data types of the columns are the same. Please check the attached .pbix files for detail.

Best Regards,

Icey

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

[ruhi]

Thank you so much!

[amitchandak]

@ruhi , I doubt that is possible.