Forum Discussion
ravijaluka
8 years agoFrequent Visitor
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 ...
v-chuncz-msft
8 years agoCommunity Support
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
8 years agoFrequent Visitor
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.