Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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)?
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
13 | |
2 | |
2 | |
1 | |
1 |