Hello,
QQ, Sorry if this sounds as a very simple / easy question ... Its just that Ive tried in several ways to do this whithout sucess:
How Do I get to have in a KPI chart a comparison YTD for 2 variables ? I am trying but what the chart shows me is the last month... please see images , what I need in the chart is the 259 K Vs 308K , not the amount for the last month ....
Thank you so much for your help !
@Geraldine Try these 2 Measures...
Use YTD Actual in Indicator and YTD Planned in Target Goals
YTD Actual = TOTALYTD(SUM('Table'[Actual]), 'Table'[Date])
YTD Planned = TOTALYTD(SUM('Table'[Planned]), 'Table'[Date])
@Geraldine Try these 2 Measures...
Use YTD Actual in Indicator and YTD Planned in Target Goals
YTD Actual = TOTALYTD(SUM('Table'[Actual]), 'Table'[Date])
YTD Planned = TOTALYTD(SUM('Table'[Planned]), 'Table'[Date])
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - February 2025
Check out the February 2025 Power BI update to learn about new features.
Fabric Community Update - February 2025
Find out what's new and trending in the Fabric community.
