align x-axis labels with bars and legend display

[facastro]

Hi,

1. How can I make the x-axis labels align with the bars?

2. How can i make the legend of the x-axis be the Status values and not a number? (I am using number to sort Status and display them accordingly.. if not, the DONE would go before In Progress, for example)

[TomMartens]

Hey @facastro ,

you can't. The reason for this is simple, unfortunately not that obvious.
You are using the clustered column chart, this type of data visual places each cluster segment "status" at the same position inside a cluster "order". Due to data distribution your visual renders correctly, even if this is wanted.
You might check the visual "stacked column chart", then of course you will have a stack, segments on top of each other, instead next to each other, instead of cluster when there are multiple "status" for the same order.

You might give the custom visual Deneb a try: https://deneb-viz.github.io/
Here you can create an order of segments inside a cluster, if there is only one segment inside a cluster, this might provide what you are looking for.

Regards,
Tom

[facastro]

@TomMartens 

Thanks! your reply helped me get to what I needed.

I changed the chart type and all good. x-axis labels are now alligned with the bars.

I still don't know how to change the status number display as text data.... but that is not a big an issue as the alignment.

[TomMartens]

Hey @facastro ,

I'm not sure if I understand your requirement regarding the sorting of the legend correctly but maybe this article is what you are looking for: https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-sort-by-column?tabs=powerbi-deskto...

Regards,

Tom