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,
The Card visual shows (Blank) when there is no data.
I know it is possible to use a new measure to replace that but that is not an option with Live Connection to multidimensional SSAS.
We could replace Null with 0 in our cube but that is not desirable at all as this shows all null records with 0s.
Is there anyway to fix this issue or just have to ask for new feature and wait forever for that to be implemented?
Really appreciate any help.
Hi,
You can hide the blank value using a Conditional Formatting rule on the Callout Value. The rule is 'if blank' then select the same color as the card or canvas background.
I have created a video tutorial on how to create the conditional rule: https://youtu.be/Xsmbfpa4oCA
Hi @Reza
As tested, this formula can help when using live connection.
Measure = IF(ISBLANK(MAX([forcast])),0,MAX([forcast]))
Best Regards
Maggie
Hi @v-juanli-msft,
I am afraid but I cannot add any new measure when using live connection to a multidimensional cube.
Everything under modeling is disabled.
Would be any other solution for this?
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 |
---|---|
106 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
147 | |
107 | |
105 | |
87 | |
61 |