Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello community,
I want to create a YTD column chart like excel graph:
I use 2 table: Actual 2023 is everything about financial statement and custom table for display date:
I try to follow the tutorial from yt video but it not display the ytd column, here is my visual:
With X-axis is Period, Y-axis is Custom Catering Profit and Legend is Catering Group. Below is dax for create Custom Catering Profit.
It not like in the yt video that only calculate net sale, my case is when i can calculate what i want, the visual must show the number of store in different group.
Hope someone can help me, if you don't understand my case, feel free to ask me.
Best regards
repeating the same data in the same visual is a design red flag. Use two visuals.
Hello lbendlin,
Thank you for you reply but my manager want to see both in one visual so is it any way to do it?
I hope someone else can help you further.
User | Count |
---|---|
69 | |
43 | |
21 | |
21 | |
14 |
User | Count |
---|---|
124 | |
42 | |
39 | |
28 | |
25 |