Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello,
I have created several measures to compare values over two different periods using KPIs. However, I have noticed that some values are missing in my KPIs.
1- When my KPIs have no value, they display "Blank". I would like to replace "Blank" with 0, so I added "+0" at the end of my measure. The problem is that 0 replaces the value of my KPI permanently. I have tried using the "IFBLANK" and "COALESCE" functions, but they did not work. How can I solve this problem? Are there other ways to replace "Blank" with 0?
2-Also, some of my KPIs show no values at all, they are literally blank. Is it because of the "Value" and "Target" values , or is it due to any filters that I have added?
If you have an idea, please let me know.
Thanks
Hi @Sami_nl ,
In order to better understand your demands and give the right solution, could you please provide some more specific information? such as your desensitized example data and a screenshot of your desired results?
Thanks for your efforts & time in advance.
Best regards,
Community Support Team_Binbin Yu
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
91 | |
81 | |
65 | |
65 | |
60 |
User | Count |
---|---|
170 | |
114 | |
102 | |
73 | |
69 |