Fiscal Week

You can achieve this by creating a calculated column in your data table that calculates the fiscal week number based on the month and year, and then use that column in your visualization. Here's an example of how you can create the calculated column:

1. In Power BI Desktop, open the data table that contains the month and year information.

2. In the Home tab, click on "New Column" to create a new calculated column.

3. In the formula bar, enter the following DAX formula:

= IF( MONTH([Date]) >= 4, WEEKNUM([Date]) - WEEKNUM(DATE(YEAR([Date]), 4, 1)) + 1, WEEKNUM([Date]) + (52 - WEEKNUM(DATE(YEAR([Date])-1, 4, 1))))

This formula uses the WEEKNUM() function to calculate the week number of the date, and the MONTH() and YEAR() functions to determine if the date is in the current fiscal year (starts from April) or the previous fiscal year. If the date is in the current fiscal year, the formula subtracts the week number of the first day of April from the week number of the date. If the date is in the previous fiscal year, the formula adds the difference between the week number of the first day of April and 52 to the week number of the date.

1. Press Enter to create the calculated column.

2. Rename the column to something like "Fiscal Week".

3. Use this column in your visualization to show the fiscal week for each month.

It's also important to note that the formula above is assuming that your date field is named "Date". If it's named something else, you'll need to adjust the formula accordingly.

You can also use the same formula but with a different approach, by creating a variable that would contain the month and year of each date, and then use the variable in the formula to calculate the fiscal week.