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 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
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 |
---|---|
109 | |
95 | |
77 | |
65 | |
53 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |