cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

Card to show 0 instead of Blank - Using two filters

Hi,

 

Have a dashboard and trying to avoid it showing (Blank) and want it to put a zero.

The Card has a filter on two different columns from the same table. One is a status - I want to show around 3 of the 8 posibilties.

The second filter is a word in the description column (Text)

 

I've found a few soltions using DAX but none with the kind of filter I am doing in the card. Can anyone help?

 

Thanks,

2 REPLIES 2
Highlighted
Super User III
Super User III

Re: Card to show 0 instead of Blank - Using two filters

Hi @mayfly ,

 

Depending on the information you are placing on the card you can make different solutions, however believe that this passes by making a measure and adding a + 0 to the end.

 

Assuming that you have make the sum of a certain column on your card the measure would be similar to this:

 

Measure = SUM(Table[Column]) + 0

 

Then depending on the filter if the information is blank it will return a 0 on your card.

 

Regards,

MFelix


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog:

Power BI em Português





Highlighted
Community Support
Community Support

Re: Card to show 0 instead of Blank - Using two filters

Hi @mayfly,

I'd like to suggest you add '+0' to your formula to replace blank to zero. (notice: '+0' not works if these blank records did not really exist in your table)

Display zero instead of blank in matrix 
Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Galleries

Galleries

Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors