Reply
Frequent Visitor
Posts: 9
Registered: ‎01-19-2017
Accepted Solution

Change to Value to zero if it does not exist

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

 

 

Capture 1.PNGBefore applying filter

 

Fig 2

 Capture 2.PNGAfter applying filter

 


Accepted Solutions
Highlighted
Regular Visitor
Posts: 43
Registered: ‎04-27-2016

Re: Change to Value to zero if it does not exist

@tobz

 

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

Show Values with no data.png

View solution in original post


All Replies
Frequent Visitor
Posts: 9
Registered: ‎01-19-2017

Change to Value to zero if it does not exist

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

 

 

Capture 1.PNGBefore applying filter

 

Fig 2

 Capture 2.PNGAfter applying filter

 

Established Member
Posts: 172
Registered: ‎05-13-2016

Re: Change to Value to zero if it does not exist

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

Frequent Visitor
Posts: 9
Registered: ‎01-19-2017

Re: Change to Value to zero if it does not exist

It didnt work for me.

Highlighted
Regular Visitor
Posts: 43
Registered: ‎04-27-2016

Re: Change to Value to zero if it does not exist

@tobz

 

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

Show Values with no data.png