Stacked Column Chart - removing axis items if the value field contains blank or zero

[MEFOX]

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

[sevenhills · Accepted solution]

Can you try in the filters, advance filtering, is greater than zero?

[daxer-almighty]

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.

[sevenhills · Accepted solution]

Can you try in the filters, advance filtering, is greater than zero?

[parry2k]

@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

[MEFOX]

The measure is 

Total Contacts = if(

ISBLANK(

DISTINCTCOUNTNOBLANK('Shared FactEventHistory'[ContactID]))=TRUE(),

0,

DISTINCTCOUNTNOBLANK('Shared FactEventHistory'[ContactID]

)

)

[Ashish_Mathur · Accepted solution]

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)