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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper IV
Helper IV

Allow the user to choose the type of date Calendar or Fiscal date



I am building a dashbord where there is a calendar date displayed as date hierarchy like the picture below.

Now the users want to have the choice to choose if using calendar date or fiscal date.


There is a way to change the date with a button ?


One important thing, i am using in this dashboard the function sameperiodlastyear that needs date hierarchy.

Also, i have a date table where i have the conversion date (below)data table.PNG


Or if someone have another solution, i take 🙂


Thank you



Collection type date.PNG


Helpful resources

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

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