Forum Discussion
Helper IIIStacked Column Chart - removing axis items if the value field contains blank or zero
The description in the axis should not show up if there isnt a value greater then 0. Can some one tell me how to prevent the axis description from appearing? thanks
Can you try in the filters, advance filtering, is greater than zero?
Hi,
Why not just this?
Total Contacts = DISTINCTCOUNTNOBLANK('Shared FactEventHistory'[ContactID])
Anyways, if you must show a 0, then try this measure
Total Contacts = COALESCE(DISTINCTCOUNTNOBLANK('Shared FactEventHistory'[ContactID]),0)
5 Replies
- parry2k
Super User
MEFOX what is the measure you are using for value? Read this post to get your answer quickly.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
MEFOXThe measure is
Total Contacts = if(ISBLANK(DISTINCTCOUNTNOBLANK('Shared FactEventHistory'[ContactID]))=TRUE(),0,DISTINCTCOUNTNOBLANK('Shared FactEventHistory'[ContactID]))- Ashish_Mathur
Hi,
Why not just this?
Total Contacts = DISTINCTCOUNTNOBLANK('Shared FactEventHistory'[ContactID])
Anyways, if you must show a 0, then try this measure
Total Contacts = COALESCE(DISTINCTCOUNTNOBLANK('Shared FactEventHistory'[ContactID]),0)
sevenhillsCan you try in the filters, advance filtering, is greater than zero?
- daxer-almighty
Solution Sage
It's very easy. You have to create a measure that will return 1 if you want to see the value and 0 if not. Then use this measure in the Filter Pane of the visual with a suitable condition.
By the way, comparing a logical value to TRUE or FALSE is totally unnecessary since a logical value already is TRUE or FALSE.
