Forum Discussion
Filter based on Switch Function that has a Top N Ranking
Hi,
I was wondering if the following is possible:
I would like to update my Brand filter to be grouped by the following:
- Our Brand ( a specific set of brands)
- DFA Brand ( a specific set of brands)
- Top 15 Brand (based on Top N by Volume Sales)
here's some dummy data:
| Group By | Brand | Category | Volume Sales |
| DFA Brands | D Brand | Category 1 | 10450 |
| DFA Brands | F Brand | Category 3 | 10000 |
| DFA Brands | A Brand | Category 1 | 9913 |
| Our Brand | Our Branded Apples | Category 1 | 12000 |
| Our Brand | Our Branded Oranges | Category 2 | 3200 |
| Our Brand | Our Branded Strawberries | Category 1 | 3500 |
| Top 15 Brands (by Volume Sales) | Our Branded Apples | Category 1 | 12000 |
| Top 15 Brands (by Volume Sales) | D Brand | Category 1 | 10450 |
| Top 15 Brands (by Volume Sales) | Blue Brand | Category 1 | 10200 |
| Top 15 Brands (by Volume Sales) | Pink Brand | Category 1 | 10100 |
| Top 15 Brands (by Volume Sales) | Yellow Brand | Category 1 | 9999 |
| Top 15 Brands (by Volume Sales) | A Brand | Category 1 | 9913 |
| Top 15 Brands (by Volume Sales) | Dog Brand | Category 1 | 9124 |
| Top 15 Brands (by Volume Sales) | Fox Brand | Category 1 | 8975 |
| Top 15 Brands (by Volume Sales) | Cat Brand | Category 1 | 8645 |
| Top 15 Brands (by Volume Sales) | Purple Brand | Category 1 | 8210 |
| Top 15 Brands (by Volume Sales) | Teal Brand | Category 1 | 7900 |
| Top 15 Brands (by Volume Sales) | Sheep Brand | Category 1 | 7000 |
| Top 15 Brands (by Volume Sales) | ABCD Brand | Category 1 | 6300 |
| Top 15 Brands (by Volume Sales) | EFGH Brand | Category 1 | 6000 |
| Top 15 Brands (by Volume Sales) | JKL Brand | Category 1 | 5000 |
5 Replies
yes, "sort a column by another column" - add a sort index column to your data that indicates the order in which the groups should appear.
Hi MichaelaMul ,
Thanks for reaching out to Microsoft Fabric Community Forum.
lbendlin Thanks for you quick response in additon that
you can refer this below doc regarding the sorted colums.
Sort a Column with a Custom Order in Power BI - RADACAD
If our response addressed by the community member for your query, please mark it as Accept Answer and click Yes if you found it helpful.Should you have any further questions, feel free to reach out.
Thank you for being a part of the Microsoft Fabric Community Forum!Hi MichaelaMul ,
We haven’t heard back from you regarding our previous response and wanted to check if your issue has been resolved.If it has, please consider clicking “Accept Answer” and “Yes” if you found the response helpful.
If you still have any questions or need further assistance, feel free to let us know — we're happy to help!Thank you!
