Change to Value to zero if it does not exist

[Anonymous]

Hi Team,

I need help on this.

I create a report using bar chart and matrix (see figure 1) but my challenge now is if select a value from the filter the two charts are no longer aligned. I need how how to manage this even if its a DAX query that sets the value that does not exist to zero so that the filed will not disappear from the charts.

Fig 1

Before applying filter

Fig 2

 After applying filter

[Anonymous]

Hi Team,

I need help on this.

I create a report using bar chart and matrix (see figure 1) but my challenge now is if select a value from the filter the two charts are no longer aligned. I need how how to manage this even if its a DAX query that sets the value that does not exist to zero so that the filed will not disappear from the charts.

Fig 1

Before applying filter

Fig 2

 After applying filter

[Anonymous]

add 

+ 0

to the end of your code.  That way, when it evaluates to a blank, it will add 0, and force a 0 to appear.  Then the column won't disappear from your matrix

[Anonymous]

Brilliant, worked like a charm!  Thanks!

[Anonymous]

It didnt work for me.

[anithat · Accepted solution]

@Anonymous

Please see the screenshot below. I hope that answers your question. 

All you have to do is to click on "Show Items with no data" from the field dropdown