Forum Discussion

Datachris3000's avatar
Datachris3000
Frequent Visitor
6 years ago

Slicer not filtering date range correctly

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!

Need Help

6 Replies

    • Datachris3000's avatar
      Datachris3000
      Frequent Visitor
      6 years ago

      Hi 

       

       

      • dobregon's avatar
        dobregon
        Impactful Individual
        6 years ago

        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