Forum Discussion

ngg4686's avatar
ngg4686
Frequent Visitor
10 years ago

Timeline slicer & variable months

I'm using this visualization and I have down pat showing "current selected" data.  What I'm wondering how to do is on the same page - show the current selected time period from the slicer (say in a b...
Need Help
Anonymous's avatar
Anonymous
Not applicable
10 years ago

Hi ngg4686,

Agree with CahabaData. When creating a measure to show data of previous year/quarter/month, you can use PREVIOUSYEAR function, PREVIOUSQUARTER function and PREVIOUSMONTH function . There is an example about how to show data of current quarter and previous quarter in this article  for your reference.

Besides, in your scenario, why not directly select date ranges in Timeline slicer and combine built-in date hierarchy of Power BI Desktop to show data in your graph? An example is shown in the following screenshot.


Thanks,
Lydia Zhang