Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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
Thanks @amitchandak and @parry2k for your reply, I have just submitted a new idea on this.
@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.
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.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@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.
@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
@Anonymous good one, I don't think that is possible, maybe add this as an idea on the ideas forum.
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.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
117 | |
104 | |
77 | |
73 | |
52 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |