Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi there,
I have a matrix with the Major Groups, Sub Groups and Paramaters where they were grouped by means of a single column named "Menu". When I checked the "Show items with no data" , it is displaying the parameters having no data as shown in the below figure.
I wanted to display the HYPHEN (-) symbol on the blank spaces on the matrix, after clicking the show items with no data. Could anyone help me to get this expected result.
Note: I tried to use this formula,
= IF ( ISBLANK(Measure), "-" ,Measure)
Sample File
Many Thanks,
Praveen.
Solved! Go to Solution.
Hi @Anonymous,
Please try this formula below.
Measure = IF ( ISBLANK(SUM('Table'[Values])), "-" ,SUM('Table'[Values]))
Best Regards,
Cherry
Hi @Anonymous,
Please try this formula below.
Measure = IF ( ISBLANK(SUM('Table'[Values])), "-" ,SUM('Table'[Values]))
Best Regards,
Cherry
Hi there,
Thank you so much for your help. I used your suggestion for my case on Measures column and it is working well.
Regards,
Praveen.
Hi @Anonymous,
You're welcome!
Best Regards,
Cherry
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |