Dynamic Piviot

[sabeensp]

Hello,

I have a single table with 5 columns COL1, COL2, COL3, COL4, COL5, Table has over 500,000 rows.

I have a slicer on COL1, now Based on value selected by users in COL1, I want to show

COL1, COL2, COL3, COL4, and COL5 Values across (Pivot)

So, IF Values of COL1 selected to be A, then there might be only 10 columns going across for COL5

Is it possible?

[v-chuncz-msft · Accepted solution]

@sabeensp 

It seems that you may simply Use matrix visualizations.