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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Anonymous
Not applicable

Create a field in slicer

Hello all,

I have custom column "Time Period" in slicer whicn contains FY2021 and FY2022 data.

So when I select FY2021, the graph will show data from fiscal month Nov 2020 to Oct 2021 similar for fiscal year 2022

 

I need  to add one more field in the slicer i.e Rolling Month, So when I select that Field data from current month till next 11 month should show i.e from March2021 to Feb2022.

 

So How to add Rolling month field in the slicer, as Time period column contains only two vaules FY2021 and FY2022

 

Krutigawale33_0-1615990076027.png

 

1 ACCEPTED SOLUTION
Icey
Community Support
Community Support

Hi @Anonymous ,

 

Please check if the attachment gives what you want:

slicer.gif

 

 

Best Regards,

Icey

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
Icey
Community Support
Community Support

Hi @Anonymous ,

 

Please check if the attachment gives what you want:

slicer.gif

 

 

Best Regards,

Icey

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.