Forum Discussion
Average 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
I have a follow-up question -- would it be possible to set the "Overall Line" to be the average revenue for a single color, and for the "Individual" line to be the average line for single account within that color?
More broadly, is it possible to have two lines on the same line graph affected by different slicers?
Hi swong,
I have a follow-up question -- would it be possible to set the "Overall Line" to be the average revenue for a single color, and for the "Individual" line to be the average line for single account within that color?
More broadly, is it possible to have two lines on the same line graph affected by different slicers?
Yes, the formula below should work in this scenario. :smileyhappy:
Overall = CALCULATE(AVERAGE(Sheet1[Revenue]), ALLEXCEPT(Sheet1, Sheet1[Date],Sheet1[Color]))
Regards
Hello 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?