How to make April the first Fiscal month for my report that has the data source OneLake data hub?

[CrisNep]

Hi all, i have to create a report that needs to be sorted by fiscal quarters. 

I can't create a new table that designates the months and quarters as the values are over 10000 rows.

As a final result i need to use those measure to create a slicer Month and Quarter

PLEASE HELP, i'm stuck.

[miTutorials]

Check out this Tutorial to Custom Sort the Months according to the Fiscal Year!

How to Sort Months by Fiscal Months in PowerBI | MITutorials - YouTube

If you don't have a calendar table in your Model - Then you should add one!

How to Create Calendar Table using DAX in PowerBI | MI Tutorials (youtube.com)

[CrisNep]

The issue with this table is that the data that i have is massive and can not be applied. 

[miTutorials]

The Error that you are getting about exceeding the limit is from the table visual.. You have not entered the right arguments when you are creating the Calendar table. Please see the link that I have posted which will let you create dynamic calendar table based on the Start Date and End Date in your data model.