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 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

Change to Value to zero if it does not exist

5 Replies

Anonymous
Not applicable
8 years ago
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
  Not applicable
  8 years ago
  It didnt work for me.
  - anithat
    Resolver II
    8 years ago
    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
- Anonymous
  Not applicable
  7 years ago
  Brilliant, worked like a charm! Thanks!
Anonymous
Not applicable
8 years ago
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

Forum Discussion

Change to Value to zero if it does not exist