How to Apply Custom Sorting in Power BI
Вставка
- Опубліковано 4 кві 2024
- Download the file⬇️ - goodly.co.in/sort-by-column-p...
Subscribe to my Email Newsletter - goodly.co.in/subscribe/
In this tutorial, we will learn how to sort months in Power BI using custom sorting techniques. When working with data in Power BI, you may encounter the need to display months in a specific order that is not alphabetical.
This video will guide you step by step on how to sort months in a custom order to achieve the desired visual representation in your Power BI reports.
===== ONLINE COURSES =====
✔️ Mastering DAX in Power BI -
goodly.co.in/learn-dax-powerbi/
✔️ Power Query Course-
goodly.co.in/learn-power-query/
✔️ Master Excel Step by Step-
goodly.co.in/learn-excel/
✔️ Business Intelligence Dashboards-
goodly.co.in/learn-excel-dash...
===== LINKS 🔗 =====
Blog 📰 - www.goodly.co.in/blog/
Corporate Training 👨🏫 - www.goodly.co.in/training/
Need my help on a Project 💻- www.goodly.co.in/consulting/
===== CONTACT 🌐 =====
Twitter - / chandeep2786
LinkedIn - / chandeepchhabra
Email - goodly.wordpress@gmail.com
===== WHO AM I? =====
A lot of people think that my name is Goodly, it's NOT ;)
My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.
Please browse around, you'd find a ton of interesting videos that I have created :) Cheers! - Наука та технологія
i always land up with this issue, thank you for sharing this instant solution
You are actually showing a 2min solution to one of my constant problems... Thank You! 👍
Wow.. thanks a lot!
Nice quick video, thanks.
In the above data, the month & year is inserted in the Rows field... How to sort the data when the month is inserted in the column fields & there is another criteria, say Name of the product, in the rows field. I want it to be sorted in descending order of product sales value..
Why course price is so high
I got a circular depency error if i want to sort by column when using a switch function to make categories. How comes it works in your video (example 3)?
In that case try to do the sort through power query
@@bharathreddy4267 that's not really a solution for me, because I defined the categories in DAX. But I figured out what caused the error. Apparently there are two ways to make it work: 1. Define the ColumnSort first and then define the categories based on the ColumnSort. 2. Define the ColumnSort based on the parent column, not the categories column.
Hi sir how to combine different sales data in power pivot.
Thank you. It's very useful. Btw, what is the screen draw that you used in the video?
Zoomit
@@GoodlyChandeep thank you
@Goodly , it was nice to learn this trick. But I didn't get the UNICHAR function logic in DAX code. Could you please elaborate more on the same?
Thanks in advance ☺️
If the month is jan then value inside unichar will be 65 and 65 is the unicode for 'A', so 'A' will appended to the year.
@veerukancharla Thanks for the clarification 👍
@@veerukancharla9271 Thanks for the clarification
The trick is that if the month was simply converted to a number as text, it wouldn't work, as 1 and 12 would sort next to each other. There are a few possible ways around this:
1) Use FORMAT to add leading zeroes -> 01 to 12 sort correctly
2) Use the UNICHAR trick so your values are A,B,C... This obviously works for months as there are 12 months and more than 12 letters in the alphabet so everything is the same length.
Since the users don't see the custom sort value, UNICHAR would be OK for most purposes. It should be avoided for larger sets as even though Unicode is large enough to generate a ton of symbols, it is not guaranteed that Power BI will sort in codepoint order.