Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

comparing two time periods on a single visual

Hi I am trying to compare two time periods in the same visual on Power BI (eg. 31/12/2015-31/12/2018 vs 31/12/2019-31/12/2022). I would like to replicate these types of charts (note it's a growth ra...
Need Help
PaulDBrown's avatar
PaulDBrown
Icon for Community Champion rankCommunity Champion
7 years ago

Anonymous 

It sounds like the second period table should be unlinked. Ie independent from any tables. 

You create new measures which calculate the output based on the dates selected in the second date table and include a slicer from the second date table. You may have to include an ALL(first date table) filter in your second measures to remove filters from the first date table in the calculations.

Sorry if I can’t be more specific but I’m not in front of a PC to check things out.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

PaulDBrown thank you for your suggestion! In the end I made this following the link that ChandakAmit sent