Columns in Slicer

[ravijaluka]

How can we have column names in a slicer such that these column names do not show up if these columns are empty???
For eg. we have 3 numeric columns T1, T2 and T3, out of which T3 is empty.  I want to show these column names in a slicer such that T3 doesn't appear on the slicer (as it is empty)?

[v-chuncz-msft]

@ravijaluka,

You may try to select Unpivot Columns in Query Editor first.

https://community.powerbi.com/t5/Desktop/matrix-to-table-help/td-p/329415

[ravijaluka]

@v-chuncz-msft 

Hi

I have tried the same while data preparation. But the problem is I have 12 columns like this. Hence I need to have them like columns anyway not the rows.