Forum Discussion

mrbartuss's avatar
mrbartuss
Icon for Advocate II rankAdvocate II
2 years ago

Show 0 when no data in clustered column chart

I have a clustered column chart with one filed on the X-axis and two measures. Example below:   If there's value either for Sales or Target, but not for both measures I would like to show 0 i...
Need Help
sevenhills's avatar
sevenhills
Icon for Super User rankSuper User
2 years ago

Try this, 

 

add a measure

Is Zero Check = IF( [Sales Target] = 0 && [Total Sales] = 0, 1, BLANK())

 

Expand or view filters pane

Drag this measure and set the filter as "Is Zero Check" is blank.

 

You get the ouput as below:

Hope it helps!

  • mrbartuss's avatar
    mrbartuss
    Icon for Advocate II rankAdvocate II
    2 years ago

    Thank you! It works, but it seems 0 has to be added to the Sales and Target measures. They are also used on other pages and visuals. As measure cannot be added as a report or even page level filter I would have to use it on all the visuals. Are there any better solutions just for the chart?