Forum Discussion

shris1993's avatar
shris1993
Frequent Visitor
2 years ago
Solved

Need Help with Clustered Chart Visual

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's avatar
    Anonymous
    2 years ago

    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.

2 Replies

  • Hi,

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

  • Anonymous's avatar
    Anonymous
    Not applicable

    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.