Sparkline sort x axis value in descending order

[Anonymous]

Just tried the new Power BI sparkline preview feature which is really cool. However, I would like to sort the x axis value by descending order but i can't find any relevant setting in the formatting. Know it can be done through dax but just see if there is a more straight way to make it.

[Anonymous]

Thanks @amitchandak and @parry2k for your reply, I have just submitted a new idea on this.

[parry2k]

@amitchandak yes 100%, but that then fixed how you want to sort, there is no UI to sort by value or x-axis, with sort by you can only sort what is on x-axis which is ok but I think having an option to sort the sparkling will bring more option, and avoid using sort by column just for the sake of sparkline. So that's why I propose to add an idea.

✨ Follow us on LinkedIn and  to our YouTube channel

Learn about conditional formatting at Microsoft Reactor

My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.

[amitchandak]

@parry2k , Yes, I agree, Idea is a must. this is just a workaround. Please share the link to vote. I will vote for it. Thanks.

[amitchandak · Accepted solution]

@Anonymous , @parry2k , I think the sort column can solve the purpose

Assume we have Month Year  and its sort column Month Year sort

Month Year = FORMAT([Date],"mmm-yyyy")
Month Year sort = FORMAT([Date],"yyyymm")

New set of columns

Month Year 1= [Month Year]
Month Year sort 1 = Rankx('Date', [Month Year] ,,desc,dense)

Use Month Year 1  in visual

Sort Month year1 on Month year sort 1 and use

[parry2k]

@Anonymous good one, I don't think that is possible, maybe add this as an idea on the ideas forum.

✨ Follow us on LinkedIn and  to our YouTube channel

Learn about conditional formatting at Microsoft Reactor

My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.