Forum Discussion
Data comparison between two date ranges
Hi guys,
I'm new to the community and I have a question
Instead of comparing Last Year, Month and etc. I want to construct two date slicers to campare data from each other, so I can let the user free for KPI comparisons.
How to do That?
Hi deegy
This article introduces a technique to filter and productively compare two time periods with Power BI.
https://www.sqlbi.com/articles/filtering-and-comparing-different-time-periods-with-power-bi/
It is better to share some exmaple data and show me what expect visual you'd like.
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
- v-juanli-msftCommunity Support
Hi deegy
This article introduces a technique to filter and productively compare two time periods with Power BI.
https://www.sqlbi.com/articles/filtering-and-comparing-different-time-periods-with-power-bi/
It is better to share some exmaple data and show me what expect visual you'd like.
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. - amitchandakSuper User
Solution with a bit different approch
Power BI : Comparing Data across Date Ranges at https://medium.com/chandakamit/power-bi-comparing-data-across-date-ranges-36be49b68613