Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Iveeerrr
New Member

Show zero instead of blanks in a matrix visual

I have already tried adding + 0 at the end of my measure and even tried COALESCE but both of those aren't working which is weird because it always worked before when I encountered this same scenario where I have to show 0 instead of blank. My suspicion is that there is no value for those blank cells in the data source which is why putting +0 at the end isn't working since those cells never get called in the first place(?)

 

Anyway, what are my options? I've recreated this scenario in the below pbix.

 

PBIX

1 REPLY 1
tackytechtom
Super User
Super User

Hi @Iveeerrr ,

 

It works if you are using dimensions instead of the attributes from the fact table:

tackytechtom_0-1677296217649.png

Here the model:

tackytechtom_1-1677296253881.png

 

DimColumn1:

tackytechtom_2-1677296298050.png

 

DimColumn2:

tackytechtom_3-1677296315205.png

 

 

Here the columns used in the visual:

tackytechtom_4-1677296340876.png

 

Does this help? 🙂

 

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/

 



Did I answer your question➡️ Please, mark my post as a solution ✔️

Also happily accepting Kudos 🙂

Feel free to connect with me on LinkedIn! linkedIn

#proudtobeasuperuser 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.