Forum Discussion
Bar Chart with one bar fixed.
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
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
2 Replies
- amitchandak
Super User
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
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.