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,
Is there a way to populate blank fields in a matrix with a value such as 0 if there is no data? In the matrix I am working on below, there are carriers that have no data for either 2022 or 2023 as you can see below and the fields are blank. If possible I would like those blank fields to be populated with a 0 if blank but I can't seem to figure it out and it seems to because there is no data for those years. Any help would be appreciated.
Thanks,
Tim
Hi,
Does this measure work?
Measure = coalesce([your measure],0)
Hi @Ritaf1983 . I tried that already and it didn't work. I still get blank fields. Any other thoughts?
Hi @TSTUTZMAN
You can also try :
if (isblank(measure), 0, measure))
or
refer to the linked video:
https://www.youtube.com/watch?v=_cT9PB72fu8
or share a link to dummy pbix without sensitive data to work with.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Hi @TSTUTZMAN
You can add 0 to your measure ( measure = abc+0)
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
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 |
---|---|
86 | |
82 | |
64 | |
63 | |
56 |
User | Count |
---|---|
171 | |
113 | |
110 | |
73 | |
73 |