Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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 !
Solved! Go to Solution.
@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])
Thank you for your help Sean ! 🙂
User | Count |
---|---|
122 | |
69 | |
67 | |
58 | |
52 |
User | Count |
---|---|
187 | |
94 | |
67 | |
63 | |
54 |