Forum Discussion
Display last week's data when selecting this week
Hi,
I was wondering if there was a way to display last week's data when selecting this weeks data.
So far I have created another table to try to create separate relationships with the filter, so that if I filter one slider, it will not effect the visualization
As seen below, when I select "Today's Week", it correctly displays the second and third ("Weekly Initiated" and "Weekly Repaired") visualizations, but it connects to the first visualization.
I want it so that if I click "Today's Week" in the slider on the right, it displays last weeks data (12/17) on the most left visualization as seen below while also displaying Today's Week data on the second and third visualization.
Please let me know if my question is confusing...
Thank you!
Sarah
- Anonymous6 years ago
i figured it out thank you
2 Replies
- MariuszCommunity Champion
Hi Anonymous
The below article is describing how to achieve it with the use of Relative Date Dimension
https://community.powerbi.com/t5/Community-Blog/Relative-Date-Dimension/ba-p/779039
Best Regards,
Mariusz
If this post helps, then please consider Accepting it as the solution. - AnonymousNot applicable
i figured it out thank you