Forum Discussion
MEFOX
Helper III
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)
parry2k
Super User
Super UserMEFOX 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
MEFOXHelper III
Helper IIIThe 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)