Slicer not filtering date range correctly

[Datachris3000]

Hi all,

I do have an issue with the date slicer and the filtering on the x-axis of my graphs. 

My date slicer doesn't work on filtering the Axis, it only filters the values. (see screenshot)

-> The measure I'm using is like this:

Rekl. (gew.) = SUM(Meldungen[Reklamationen])+0

-> the +0 is there, because I need to see data points with 0 complaints (=Reklamationen) as well...

I guess there is a quite easy solution for my issue.

Thank you in advance!

[amitchandak]

@Datachris3000 , if you add +0, it will become left join and all data point in the calendar will be shown.

[Datachris3000]

Hi amitchandak,

thank you for your quick reply!

Do you know how to change the measure, so that it

• sums up values
• outputs 0 if there are "no data"
• is filtered correctly by slicers?

That could solve the problem

[dobregon]

could you try with a measure

measure = 
var A = SUM(your sum)
Return
if(isblank(a),0,a)

I imagine that your X axis from dates are not in the same table that your values right? because if they are in the same table (dates and values) you will not have this problem. 

In any case, check your relationship between both tables

[Datachris3000]

Exactly, the values are in two different tables.

The measure itself works, but it doesn't solve the problem to filter out the values outside of the slicer date range. At least not for the 2nd visual with following measure: 

Measure 2 = Divide([Rekl. (gew.)],[Lieferungen],1)

[Anonymous]

Hi @Datachris3000 ,

Can you upload your .pbix file to onedrive business and share the link with us?Do remember to cover the confidential information.

Much appreciated.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[dobregon]

@Datachris3000 what type of relationship you have between both tables? try to change to cross filter