Showing data by fiscal year

I have a table with info as below:

Project 2022 2023 2024 2025 2026

A 100 75 0 0 0

B 0 100 25 25 25

C 0 10 15 5 5

How do I set up a slicer for Fiscal Year?

1 REPLY 1

You add a calendar table (with your fiscal year conditions) to your data model.

Helpful resources

Announcements

Check out the November 2025 Power BI update to learn about new features.

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

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.