Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |