Forum Discussion
Helper IIAverage over time vs. sliced average
Hi swong,
I have reviewed your shared pbix file. And I find that there is no problem with the formula of the measures. Instead of using Date hierarchies as Axis, you should use the Date column itself as Axis, then it will work as expected. :smileyhappy:
Here is the modified pbix file for your reference. :smileyhappy:
Regards
Helper IIHello again!
Whe I add date as a slicer for my table, it works fine.
However, I'd like to have two line graphs both affected by the same date slicer. I thought to do this by creating and aux table, where each distinct date has a distinct value, the creating a relationship between Date1 of Table1 and the aux table, and a relationship between Date2 of Table2 and the aux table.
The slicer based on the aux table's Date column affects both individual lines on my two line graphs, but not the overall line. Is there a way to make this slicer affect all lines?