Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.