Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
I have a 100% stacked column chart in PBI desktop and on the legends well I have a column with below shown values (Text Values)
I do not want this to be sorted using the values in this column. However, I want to sort by using the order shown in below snip (meaning Green one on Top followed by number 2 and then 3 and so forth and so on) if there is not any number in the table after number 1 then I want the next number to show up which is currently number 5
I have created a conditional column within this table using Power query shown below and then used this column to sort the chart but still its not sorting the way I need
I then went inside the PBI desktop (Table View) and sort this table using the newley cretaed (Custom Sort) column
what I get is this, I want the Green colour (HSF Accepted by NRG Deliverable Complete) to show on top of the chart.
What is the alternate way to achieve this
Hello @smjzahid ,
To sort based on Legend.
1)Click on the visual and press 3 dots at the top right corner of visuals as shown in picture.
2)Click on the "Sort by" dropdown and select "Value".
3)Choose the sort order as either "Ascending" or "Descending" based on your preference.
4)Click "OK" to apply the changes.
NO that will sort on the values in the legends column in this case the legen column is Status and it has values as shown in below snip so its sorting those values alphabetically with ALDE/DPE CEM Review Process starting with A first and followed by other, Thats not my requirement
I want the GREEN COLOUR (HSF Accepted by NRG to be the first and then followed by others (please read my requirement above)
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the February 2025 Power BI update to learn about new features.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
84 | |
69 | |
68 | |
39 | |
37 |