Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all,
i was wondering if it's possible to add a YTD bar to a visual that shows the weekly revenue of the last week.
i have this graph that shows revenue of the week vs revenue of previous week filtered by week and year, my question is if i could add a third bar that shows the revenue of the year until that week selected. Thanks
Regards
Hi @Astolfo ,
Yes you can add YTD bar to this visual .
You can use this calculation for YTD
For example :- YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(('Date'[Date]),"4/30"))
It would look something like this
Thanks,
Pratyasha Samal
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
Proud to be a Super User!
User | Count |
---|---|
91 | |
73 | |
68 | |
63 | |
55 |
User | Count |
---|---|
99 | |
88 | |
73 | |
60 | |
58 |