Forum Discussion
Solved
YOY Bar chart sorting
Hi, I have a bar chart showing YOY Sales data per Category. So I can show Sales in 2020 and 2021 for each Category in a bar chart. I need to sort Categories by recent year and sales data, no...
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! 😄
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
So this is what I need in the end.. 10 rows, sorted by 2021, and showing Sales in €