Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
Super User

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!
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

@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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.