Chart visualization

[Anonymous]

Hello everyone!

This is my first post here and I am brand new with the program. 

I would like to replicate this graph in PowerBI

This is the raw data:

Sede	MARCA	Total Ventas
Ate	TOYOTA	23,931,919
Ate	SUZUKI	20,280,163
Ate	HONDA	12,411,282
Ate	VOLVO	10,408,631
Ate	HYUNDAI	8,375,785
Ate	MAZDA	6,205,326
San Miguel	TOYOTA	23,857,777
San Miguel	SUZUKI	18,072,908
San Miguel	HONDA	13,106,045
San Miguel	VOLVO	11,569,275
San Miguel	HYUNDAI	8,748,502
San Miguel	MAZDA	6,217,693

But with PowerBI it is concatenating the labels. 

Thanks in advance

[Anonymous]

Thank you! I got the same graph. I'll try the charticulator! (I use the measure but the Graph again looks weird). In case you've done, can you share what's the final image?

[mahoneypat · Accepted solution]

To avoid the concatenated labels, you'll need to sort by your x-axis category columns.  

But to also sort by descending values, I believe you'll need to create the chart in charticulator, possible with a Sort Measure like this one.

Sort Measure = MIN(Data[Sede]) & FORMAT(SUM(Data[Total Ventas]), "0000000")

(15) Austin Power BI User Group - Charticulator 101 - YouTube

Pat