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

Filter/Slicer to show next 6 months

Hi,

 

I'm still learning Power BI and ran into an interesting problem. I am looking to display 6 periods of data (periods are based on fiscal calendar) and want to have a season filter dynamically display the rolling 6 months. 

 

The filter I had in mind would be "Season" and would like to show one month prior to the current season and two months after. For example, if I selected Winter, I would show Sept, Oct, Nov, Dec, Jan, and Feb on a corresponding table.

 

I currently have a table that includes Fiscal Week, Fiscal Month, Fiscal Year; I've created a Fiscal YearMonth column to see if I can try to establish a filter and select the next 6 months out, but I am hitting a mental road block. Anyone have any suggestions on how I can accomplish this dynamic filter?

 

Thanks!

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator v-sihou-msft
Moderator

Re: Filter/Slicer to show next 6 months

@pager

 

In this scenario, you need to create a Season-Calendar table, and don't create relatioship to any table. I assume you create Year slicer and Season slicer.

 

Then you can create a check measure in existing table to tag if dates/months are within selected 6 months based on selection in that "non-related" Season-Calendar Table. Use the check measure in Visual Level Filter.

 

For more details, please refer to solutions in threads below:

 

http://community.powerbi.com/t5/Desktop/undefined/td-p/164930

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

 

Regards,

1 REPLY 1
Moderator v-sihou-msft
Moderator

Re: Filter/Slicer to show next 6 months

@pager

 

In this scenario, you need to create a Season-Calendar table, and don't create relatioship to any table. I assume you create Year slicer and Season slicer.

 

Then you can create a check measure in existing table to tag if dates/months are within selected 6 months based on selection in that "non-related" Season-Calendar Table. Use the check measure in Visual Level Filter.

 

For more details, please refer to solutions in threads below:

 

http://community.powerbi.com/t5/Desktop/undefined/td-p/164930

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

 

Regards,