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.
Hi,
Is it possible to show the column names in a matrix visualization even when there are no values for that column ? I want to show column name with empty rows.
Solved! Go to Solution.
Hi @SR1,
What about creating a calculalted column with IF and ISBLANK function like below.
Column = IF(ISBLANK('Table Name[Column Name]),"Column Name")
Then use this calculated column in matrix columns field.
If you still need help, please share some data sample and your desired output sothat we could help further on it.
Best Regards,
Cherry
Hi @SR1,
What about creating a calculalted column with IF and ISBLANK function like below.
Column = IF(ISBLANK('Table Name[Column Name]),"Column Name")
Then use this calculated column in matrix columns field.
If you still need help, please share some data sample and your desired output sothat we could help further on it.
Best Regards,
Cherry
Hi - Have you tried right clicking on the dimension you want to see everything for and select Show Items With No Data
@davehus Thanks for replying. Yes that option is checked. But I don't see the column names with no data.
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 |
---|---|
114 | |
100 | |
81 | |
70 | |
62 |
User | Count |
---|---|
148 | |
116 | |
104 | |
90 | |
65 |