Has anybody done a RANKX on multiple columns please?
I have been looking at different solutions in the Power BI community etc. but none of them have been satisfactory so far.
Let’s say I have the following columns:
Products, Period and Total Sales
Products: Name of all the products
Period: AY and LY (actual year and last year)
Total Sales: self-explanatory
In the Table Visual you can only sort by 1 measure so far, unfortunately.
What I would like is:
- Sort by Highest Total Sales (DESC)
- Sort by Product (ASC)
- Sort by Period (ASC -> AY comes first, then LY)
Product AA - AY - Total Sales
Product AA - LY - Total Sales
Product BB - AY - Total Sales
Product BB - LY - Total Sales
Does anyone have an idea how to achieve this please?
Thanks in advance for your help.