Power BI sales report previous year, Current year based on Fiscal year

[Naveen123]

Hi All,

I am new to power BI looking for help from you all. Fisal year: 01-July to 30-June  I am trying to create a sales dashboard in PowerBI desktop based on Fiscal year as previous year sales and current year sales.

SALES DATA:

Branch	Department	Transaction Date	Fiscal Year	Sales
1	A	24/03/2023	2022-23	645.32
1	B	28/06/2021	2020-21	214.11
2	A	12/05/2022	2021-22	310.00
2	B	30/01/2023	2022-23	210.99
2	A	11/07/2023	2023-24	115.67

EXPECTED RESULT:

Branch	Previous Year 2022-23	Current Year 2023-24
1	645.32	0.00
2	210.99	115.67

[Arul · Accepted solution]

@Naveen123 ,

You can do this with matrix visual by applying fiscal year filter on visual level. Please refer the image attached,

Thanks,

Arul

[Naveen123]

Thanks Arul!