Forum Discussion
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) ...
Datachris3000 , if you add +0, it will become left join and all data point in the calendar will be shown.
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
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 tablesExactly, 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)
Datachris3000 what type of relationship you have between both tables? try to change to cross filter
