Financial Year Data comparison with previous years

Hi MAruna,

Yes, this is achievable.
For previous year comparison, instead of adding CY + PY, return only PY when Previous Year is selected, and make sure the FY text (e.g. 2024-2025) is correctly derived from the selected FY. This will allow a clean comparison between 2025–2026 vs 2024–2025.

For “No data available”, measures can’t add bars, but you can:

Use a measure returning BLANK() for missing months

Add a dynamic title or tooltip showing “No data available for this month”

Helpful sources:

CALCULATE & filter context: https://learn.microsoft.com/dax/calculate-function-dax

SELECTEDVALUE in slicers: https://learn.microsoft.com/dax/selectedvalue-function-dax

Handling BLANK() in visuals: https://learn.microsoft.com/power-bi/create-reports/desktop-handling-blank-values

Microsoft Learn (recommended):

Create measures using DAX in Power BI: https://learn.microsoft.com/training/modules/create-measures-dax-power-bi/

Savio Ferraz | Microsoft Learning Consulting | Google Certified Trainer and Microsoft Certified Educator

Did my answer help? Mark my post as a solution or like it if you found it useful.