Forum Discussion
YOY Bar chart sorting
- 5 years ago
Ok, I managed to do what I need.
I created rank of Categories by Sales in 2021, put the rank in Tooltips and sorted on Tooltip. 🙂
I haved learned something today! 😄
AgencyPowerBi , is the Category on axis, Then you can sort on three dots.
if it legend it will on sort alphabetical or on sort column
https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column
- AgencyPowerBi5 years agoHelper III
Ok, I managed to do what I need.
I created rank of Categories by Sales in 2021, put the rank in Tooltips and sorted on Tooltip. 🙂
I haved learned something today! 😄
- AgencyPowerBi5 years agoHelper III
These things I know how to do, unfortunatelly it is not what I need
Best way to do it would be to make a table, out of categories, sales and two years.. pivot the years so they would go into columns and make the visual.
Is it possible through dax?
For visualisation platform, simple things seem daunting 😕
Thank you very much
- AgencyPowerBi5 years agoHelper III
So this is what I need in the end.. 10 rows, sorted by 2021, and showing Sales in €