Forum Discussion
Columns in Slicer
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)?
2 Replies
You may try to select Unpivot Columns in Query Editor first.
https://community.powerbi.com/t5/Desktop/matrix-to-table-help/td-p/329415
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.
