Stephane Viot on 07 Oct 2015 23:52:58
Count of should return 0 instead of '(Blank)' (looks better on a Dashboard)
- Comments (51)
RE: Count should return 0 instead of (Blank)
I agree
RE: Count should return 0 instead of (Blank)
Fully agree with most comments below. Please guys, this is such a simple change to make. You can't use the basic tools for simple counts, where a zero value will result in (blank) being displayed on screen. Having to define a custom measure for each one of these seems like a lot of work for something that should be this simple.
Please just provide the option to show 0 as the number zero or the text (blank). It's that simple.
RE: Count should return 0 instead of (Blank)
really helpful function. such as line chart
RE: Count should return 0 instead of (Blank)
Count with no Blanks = IF(DISTINCTCOUNT(Table[Value]) = BLANK () ,0,DISTINCTCOUNT(Table[Value]))
RE: Count should return 0 instead of (Blank)
This is a redundant request with 16587064. Please fix & close both!
RE: Count should return 0 instead of (Blank)
Hi all,
sorry if this has already been discussed, but I am quite new to Power BI and I need some help with cards; I am using an average to show value in cards which are linked to slicers; the issue is that if there are no data for a certain brand selected, then the card shows "blank" which is not ideal to see. Is there a way to change this "blank" to either zero or "no data"?
Thank you for your help
RE: Count should return 0 instead of (Blank)
I agree with previous user comments, when using external clean datasets and using the count feature from Power BI it would be nice to have the option to return "Blank" or "0" instead of a simple default to "Blank".
For dashboards displays that are number intensive displaying the word "Blank" tends to lead the intended audience to think that there is an issue with the dataset.
Thanks.
RE: Count should return 0 instead of (Blank)
It would be nice if you add this feature to Power bi.
RE: Count should return 0 instead of (Blank)
You should have the option to return Blank or 0
RE: Count should return 0 instead of (Blank)
If you have multiple cards and the value shows blank then it's time consuming to write an IF measure for every card. Just seems time consuming and not a very efficient way to display values. Suggestions of putting 0 or None automatically generated from DAX would make it much easier to track values.