cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Ayupchap
Helper III
Helper III

Ordering issue on a visual

I am trying to sort by quesiton but as you can see its not quite working out.  Is there anythign I can do to fix this?

 

sort issue.PNG

1 ACCEPTED SOLUTION
Vvelarde
Community Champion
Community Champion

@Ayupchap

 

Hi, you need a extra column with the order.

 

Demo:

 

Question   Order

Question 1   1

Question 2   2

Question 10   10

 

After that go to modeling Sort By Column and Select Order Column.




Lima - Peru

View solution in original post

2 REPLIES 2
Vvelarde
Community Champion
Community Champion

@Ayupchap

 

Hi, you need a extra column with the order.

 

Demo:

 

Question   Order

Question 1   1

Question 2   2

Question 10   10

 

After that go to modeling Sort By Column and Select Order Column.




Lima - Peru

You can probably use the Query Editor to help you with this.

 

Highlight the column wtih the the text "Question 1" etc, then click the Transform tab and then the Split Column button to split by delimiter.

 

This will give you a new column with just the number component (so long as your data is consistent)

 

Split by delimiter.png

 

 

You can then set this solumn to be numeric and use this as your "Sort By Column" back in Power BI

 

Sort by mont.png


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.