cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply

My Year and Quarter is not sorting correctly in a visual

daniellamoore29_0-1695819789664.png

 

I have a merged column 'FY Q' which shows the financial year and quarter, however this is not sorting correctly. The visual should show 2023-1, 2023-2, 2023-3, and 2024-4. 

 

How do I solve this please?

1 ACCEPTED SOLUTION
audreygerred
Impactful Individual
Impactful Individual

Hello! This looks like it is sorted by the values of the columns. If you hover on the visual and click the 3 dots, you should get an option to 'Sort axis' and from there you can specify to sort by the values or the date and ascending or descending order.

audreygerred_0-1695820625772.png

audreygerred_1-1695820681181.png

 

 

View solution in original post

1 REPLY 1
audreygerred
Impactful Individual
Impactful Individual

Hello! This looks like it is sorted by the values of the columns. If you hover on the visual and click the 3 dots, you should get an option to 'Sort axis' and from there you can specify to sort by the values or the date and ascending or descending order.

audreygerred_0-1695820625772.png

audreygerred_1-1695820681181.png

 

 

Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors