Bar Chart with one bar fixed.

[Anonymous]

Hi @amitchandak 

I have sales data for multiple countries[let's say - India,USA,UK,Africa,Australia] of 5 years.

I would like to create a bar with year and country on the X-axis and sales on the Y-axis with India fixed at the first bar for every year and other 4 countries order on the basis of sales.

Is that possible? If yes then how.?

Thanks 

[amitchandak · Accepted solution]

@Anonymous , No, I doubt that. As of now, we can only sort on column or measure.

So we can force India to come first by having a sort column.  But can not make others sort on dynamic year value.

Statics yes we can(overall revenue) . https://www.youtube.com/watch?v=KK1zu4MBb-c

[Anonymous]

Thanks @amitchandak 

I was able to achieve a solution by ranking the countries using switch and then sorting the country column on the basis of rank(circular dependency was coming, to overcome that i have create a duplicate of country column and sort the dupliate of country by rank and using duplicate country column in bar char).
If there is any other way please let me know.