Forum Discussion
Sorting slicer
Hello community,
I need help with sorting a slicer that is using a column with number and text.
| Metric_Group |
| 1 |
| 5 |
| 20 |
| 45 |
| 100 |
| 115 |
| A |
| B |
F |
I have Metric_group from 1-150 and A-S. How do I sort the number 1-150 in order? A-S should come after the numbers.
Hi Anonymous
Thank you for reaching out to the Microsoft Community Forum regarding your query.
To sort a slicer that uses a column containing both numbers and text , please follow the steps below:
1. Create a new column in Power BI using the following DAX:Sort_Order =
VAR TryNum = IFERROR(VALUE('MetricTable'[Metric_Group]), BLANK())
RETURN
IF(
NOT ISBLANK(TryNum),
TryNum,
1000 + UNICODE(UPPER('MetricTable'[Metric_Group]))
)
2. In Data view, select the Metric_Group column and apply Sort by Column choose the Sort_Order column then use the Metric_Group column in slicer visual.I have also attached a snapshot and PBIX file for your reference please review it.
If my response has resolved your query, please mark it as the Accepted Solution to assist others. Additionally, a 'Kudos' would be appreciated if you found my response helpful.
Thank YouMicrosoft Fabric Community Support!
4 Replies
Add a extra column with distinct integers that match up with the sort order you want. Set the metric value column to be sorted by the new column
Hi Anonymous
Thank you for reaching out to the Microsoft Community Forum regarding your query.
To sort a slicer that uses a column containing both numbers and text , please follow the steps below:
1. Create a new column in Power BI using the following DAX:Sort_Order =
VAR TryNum = IFERROR(VALUE('MetricTable'[Metric_Group]), BLANK())
RETURN
IF(
NOT ISBLANK(TryNum),
TryNum,
1000 + UNICODE(UPPER('MetricTable'[Metric_Group]))
)
2. In Data view, select the Metric_Group column and apply Sort by Column choose the Sort_Order column then use the Metric_Group column in slicer visual.I have also attached a snapshot and PBIX file for your reference please review it.
If my response has resolved your query, please mark it as the Accepted Solution to assist others. Additionally, a 'Kudos' would be appreciated if you found my response helpful.
Thank YouMicrosoft Fabric Community Support!
Hi Anonymous
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.
v-karpurapud That worked!!
Thank you for your help.
