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)   ...
Need Help
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
Datachris3000's avatar
Datachris3000
Frequent Visitor
6 years ago

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)

  • dobregon's avatar
    dobregon
    Impactful Individual
    6 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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!