Issue with Stacked Colum Chart

[Optimusprime_25]

I have a requirement where I have to show data in a Stacked Column Chart.

In X-axis I have current year MTD and previous year MTD, basically those are measures.

In Y axis I have to show data according to the Product.(Dimension)

In Product I have 3 different categories in product which are A,B and C.

So now I have to show data for current year sales mtd 2024 and previous year sales mtd 2023 in X axis for different categories (product) in Y axis

[Gabry]

So what's your issue?

[Optimusprime_25]

Asper requirement we have to show the data in stacked column chart but the data which we have we couldn't able to show that.

In Stacked column chart we can show only categories in X axis and in Y axis we can show only measures, butaccording to the reuirement we have to show vice versa.

we have to show previous year mtd and current year mtd in x axis and Categories in Y axis.

[v-yilong-msft]

Hi @Optimusprime_25 ,

I create a table and two simple measures as you mentioned.

mtd 2023 = CALCULATE(SUM('Table'[2023-1])+SUM('Table'[2023-2]))
mtd 2024 = CALCULATE(SUM('Table'[2024-1])+SUM('Table'[2024-2]))

When we select the Stacked column chart, we can not let the mesures in X-axis. We just can let them in Y-axis.

I think you can use Stacked bar chart. It can let the measures in X-axis.

It can also get what you want.

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Optimusprime_25]

Hello @v-yilong-msft , 

Thanks for your response.

@Ritaf1983 @amitchandak @Idrissshatila @Daniel29195 Could you please help me to resolve the issue.

We have to show the chart in below way.

We have Filetrs as Month and Year based on the selected fulter values we have to show data accordingly in below charts.

We have separate measures for current year and previous year. We have to show data according to the Categories for the selected year and it's previous year.

Instead of measures in stacks we have to show category in stacks. I hope you got the requirement.

Thank you.

[Ritaf1983]

Hi @Optimusprime_25 
Unfortunately, I didn't understand what are you trying to do...
There are just tables in the image, can you show the desired graph?

[Optimusprime_25]

Hi @Ritaf1983 ,

Thanks for your response.

Below is the sameple data for the month of January, 2024.

Categories	Date	Month	Year	Sales
A	1/1/2024	jan	2024	3
B	1/2/2024	jan	2024	4
C	1/3/2024	jan	2024	4
D	1/4/2024	jan	2024	4
E	1/5/2024	jan	2024	4
A	1/6/2024	jan	2024	3
B	1/7/2024	jan	2024	4
C	1/8/2024	jan	2024	4
D	1/9/2024	jan	2024	4
E	1/10/2024	jan	2024	4
A	1/11/2024	jan	2024	3
B	1/12/2024	jan	2024	4
C	1/13/2024	jan	2024	4
D	1/14/2024	jan	2024	4
E	1/15/2024	jan	2024	4
A	1/16/2024	jan	2024	3
B	1/17/2024	jan	2024	4
C	1/18/2024	jan	2024	4
D	1/19/2024	jan	2024	4
E	1/20/2024	jan	2024	4
A	1/21/2024	jan	2024	3
B	1/22/2024	jan	2024	2
C	1/23/2024	jan	2024	2
D	1/24/2024	jan	2024	2
E	1/25/2024	jan	2024	2
A	1/26/2024	jan	2024	3
B	1/27/2024	jan	2024	2
C	1/28/2024	jan	2024	2
D	1/29/2024	jan	2024	2
E	1/30/2024	jan	2024	2
A	1/31/2024	jan	2024	2

In the similar waywe have data for previous years such as 2022 and 2023 for different Categories as you can see in the data.

Nowe  we have to calculate the MTD sales and YTD sales for the selected Month and Year for different categories and show it is Stacked column chart.

Ex: 

How to write the measures. We have to show MTD selected year, MTD Previous year, YTD Selected year and YTD Previous year in X axis and in Y axis we have to show data according to different categories.

Thank you.

[v-yilong-msft]

Hi @Optimusprime_25 ,

Still the original problem, if you want to put measure on the X-axis of the Stacked column chart is unlikely, because desktop does not support it.

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.