Need Help with Clustered Chart Visual

[shris1993]

I have a visual like below , which shows the total order sum by week and month. I have Mont name and week sequence number in my rows.
Then I have total order and shipped order as value.

However , I want to see the above visual in the below format., where the week sequanace label is off. I can only see month on the x-axis.

How can i do it? Do i need to do some change at visual level or do i need to have some dax calculation for the total order and shipp order that can sum the amount by week sequence.

[Anonymous · Accepted solution]

Hi @shris1993 ,

First of all, many thanks to  for your very quick and effective replies.

Based on my testing, please try the following methods:

1.Create the simple table.

2.Drag the month and year field into the column chart.

Best Regards,

Wisdom Wu

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

[Ashish_Mathur]

Hi,

In the formatting options, see if there is a way to colour the week font label to white.