Forum Discussion
Dynamically filter 2 periods for Waterfall chart
I need to create a waterfall chart with periods as a Category, that is dynamically filtered by a slicer. Waterfall chart needs to display both periods - the one selected and the previous one. That is not possible when slicer iteracts directy with the chart.
Wrong:
What's required:
How do I filter 2 periods for the chart?
Note, this is a live connection to SSAS, so no calculated columns or tables possible.
Hi dpopks,
Beacause you use live connection in powerbi, so to achieve your goal, you need to create a slicer dimension like below
And make sure you have datetype value in your date dimension. You could refer to my sample
Best Regards,
Zoe ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Hi dpopks,
Beacause you use live connection in powerbi, so to achieve your goal, you need to create a slicer dimension like below
And make sure you have datetype value in your date dimension. You could refer to my sample
Best Regards,
Zoe ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.