Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I have the following Clusterd line chart that put the total on the top of each column divided by reagion, but I want the total by year as you can see in the follwing figure.
Can anyone help?
You can add two card visual above the column chart.
You can create two measures first.
2022 = CALCULATE(SUM('Table'[Value]),'Table'[Year]=2022,ALL('Table'))
2023 = CALCULATE(SUM('Table'[Value]),'Table'[Year]=2023,ALL('Table'))
Then put them to the visual card.
Output
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
Thanks for the feedback, but i wanted the chart was dinamic, change the values between 2017-2023...
Regards,
João Oliveira