Multiple x-axis variable PBI

[JoaoOliveira7]

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?

[v-xinruzhu-msft]

Hi @JoaoOliveira7 

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.

[JoaoOliveira7]

Hi,

Thanks for the feedback, but i wanted the chart was dinamic, change the values between 2017-2023...

Regards,

João Oliveira