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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
jamesob
New Member

Show a zero when there is a blank in the slicer selection

Can someone please explain how I change all visualisations on a multi-page dashboard to show a zero when a slicer selection has come across a blank, therefore either replacing a 'blank' in the data cell with '0' or still showing the visualisation instead of it disappearing all together if all are blanks?   It is doing my head in as I have looked at various ways on different forums and I dont want to be reproducing new measures for everything as that seems a complete waste of time and effort.  Is there a simple way?  Thank you

2 REPLIES 2
v-easonf-msft
Community Support
Community Support

Hi , @jamesob 

I'm afraid that there is no one-size-fits-all method.For each visualization ,you need to write a specific measure.

Hope others can come up with  an easy way for entire report.

 

Best Regards,
Community Support Team _ Eason

 

Greg_Deckler
Super User
Super User

I do not know of an easy way for an entire report although I thought that visuals had a "show zero values" or something like that.

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

April Fabric Community Update

Fabric Community Update - April 2024

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