Forum Discussion

MEFOX's avatar
MEFOX
Icon for Helper III rankHelper III
5 years ago
Solved

Stacked 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        
Need Help
  • sevenhills's avatar
    sevenhills
    5 years ago

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

  • Ashish_Mathur's avatar
    Ashish_Mathur
    5 years ago

    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)

sevenhills's avatar
sevenhills
Icon for Super User rankSuper User
5 years ago

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