topic Re: Columns in Slicer in Developer

Columns in Slicer

ravijaluka — Tue, 24 Jul 2018 12:40:29 GMT

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)?

Re: Columns in Slicer

v-chuncz-msft — Wed, 25 Jul 2018 09:46:32 GMT

@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

Re: Columns in Slicer

ravijaluka — Wed, 25 Jul 2018 09:59:18 GMT

@v-chuncz-msft

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.