Hello,
I write here because they asked me to do that here: https://community.fabric.microsoft.com/t5/Desktop/Comparing-last-12-months-to-previous-12-months-par...
I have 2 formula's.
1. Revenue LY Per Month - for chart = CALCULATE([Revenue this year Per Month - for chart], SAMEPERIODLASTYEAR('Calendar Table'[Date]))
2. Revenue this year Per Month - for chart = SUM(KPI_EOL_sync_financial_transactionlines[Revenue])
My visual column diagram looks like this. Where green is revenue this year and blue revenue last year.
If I hover over aug 2025, for last year I still see "aug 2025" and not "aug 2024".
How can I fix this?
2. Revenue this year Per Month - for chart = SUM(KPI_EOL_sync_financial_transactionlines[Revenue])
My visual column diagram looks like this. Where green is revenue this year and blue revenue last year.
If I hover over aug 2025, for last year I still see "aug 2025" and not "aug 2024".
How can I fix this?
- Ghoom on: Azure Maps Controls -> Selection Greyed out
-
awright19
on:
Open old report, PowerBi hangs
-
mattlee
on:
Error：Visuals display blank when export report to ...
-
AlenaT
on:
New Button Slicer: Issue with the Grid type of Arr...
-
mattlee
on:
List Slicer Button Dimensions Ignored in Service
-
bhalicki
on:
BUG: report connected to deleted semantic model ca...
- Annamarie on: PBI Semantic Model missing
- SeanGTB on: Azure Map visual auto zoom issue with 3D columns
- Ghoom on: Azure map bubble chart is very blurry
-
JoshT
on:
Deployment pipelines don't support M365 groups