cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JackyChoi
Frequent Visitor

slicer past 12 months

Hi all,

 

Is there a way to have a bar graph shows the past 12 months data based on the slicer date value selected by the user? As I need historical data for other analytics... I cannot just filter out from query...

 

I've tried looking at some solutions online... most of them uses the function "now" instead of a slicer.

 

Thanks

1 ACCEPTED SOLUTION
CheenuSing
Community Champion
Community Champion

@JackyChoi

 

Please go through the link

 

http://community.powerbi.com/t5/Desktop/Show-last-13-months-based-on-user-single-slicer-selection/m-...

 

Cheers

 

CheenuSing

Did I answer your question? Mark my post as a solution and also give KUDOS !

Proud to be a Datanaut!

View solution in original post

5 REPLIES 5
GilbertQ
Super User II
Super User II

Hi there

 

You can look at my data story below, where I create Periods, which in theory could be any period you like. 1 Month Back, 13 Months, YTD, etc.

 

So in there you can create your own period and then put this as a slicer for people to use. And I find that this is a lot easier to create, complete and has many other uses.

 

http://community.powerbi.com/t5/Data-Stories-Gallery/Create-Dynamic-Periods-for-Fiscal-or-Calendar-D...





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

CheenuSing
Community Champion
Community Champion

@JackyChoi

 

Please go through the link

 

http://community.powerbi.com/t5/Desktop/Show-last-13-months-based-on-user-single-slicer-selection/m-...

 

Cheers

 

CheenuSing

Did I answer your question? Mark my post as a solution and also give KUDOS !

Proud to be a Datanaut!

View solution in original post

JackyChoi
Frequent Visitor

I think somebody has already asked the question.

 

https://community.powerbi.com/t5/Desktop/Dynamic-Display-Last-12-Months-in-Visual-According-to-Month...

 

 

 

If anyone knows any solution, please assist.

 

 

Thanks

KHorseman
Community Champion
Community Champion

@JackyChoi Let me see if I understand what you're asking for. You want a slicer where the user selects a single date, and a measure that gives a total for the 12 months preceding the date they've selected?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




@KHorseman Not quite, I would like the bar graph to shows the past 12 months performance by month.

 

I have a date column, which is the slider in this case. Once a user select Aug 2016, the graph should show Sept 2015 - Sept 2016 (total of 12 columns)

 

Does that make sense?

Helpful resources

Announcements
MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Top Solution Authors
Top Kudoed Authors