Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I do have a Problem:
In this line chart there should be shown the cumulated turnover for the years 2016 and 2017. I have created a measure for the cumulated turnovers per year, because I want them to be shown month by month. Now in this case somehow only the cumulated turnover for 2017 is shown in the chart, the cumulated turnover for 2016 isn't even shown on the chart. Anyone a clue why this happens and why the cumulated turnover for 2016 isn't shown?
Solved! Go to Solution.
Create relationship between the new table and your calendar table using Date field. Then create YTD using the similar formula below and create Line chart as follows.
YTD = TOTALYTD(SUM(NewTable[field]),'Calendar'[Date])
Regards,
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |