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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
bensimpsy
Frequent Visitor

Sorting Column Dates in a Matrix Table

Hi All,

 

I am hoping to get some assistance using the Power BI Service.  I would like to create a matrix table that shows sales figures by month for a list of subsidiaries.  I can create the matrix fine, but it sorts the dates in alphabetical order instead of the expected month order:

bensimpsy_0-1712625494158.png

If instead of using the month names, I use the month numbers this works fine. However I want to use the month names as the column headers not the month number.  I also do not want to have to use a combination of month number and name (ie. 01 January, 02 February).

 

I have tried the advice in this article, however there is no tooltip available for a matrix, so I could not follow these instructions beyond step 3: https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-sort-by-column?tabs=powerbi-servic...

 

The current configuration looks like:

bensimpsy_1-1712625783724.png

I have a Date table setup with a relationship to my sales table, and the date table looks like the following:

bensimpsy_2-1712625867456.png

Any help appreciated.

 

Regards,

Ben

1 ACCEPTED SOLUTION
bensimpsy
Frequent Visitor

I've managed to solve this by editing the Semantic Model, selecting my Date table -> Month_Name field and then in the Advanced Settings there was an option to select a sort by column.

bensimpsy_0-1712651446185.png

This then sorted the columns in the Chronological order.

bensimpsy_2-1712651651608.png

Hopefully this helps someone in future.

View solution in original post

3 REPLIES 3
bensimpsy
Frequent Visitor

I've managed to solve this by editing the Semantic Model, selecting my Date table -> Month_Name field and then in the Advanced Settings there was an option to select a sort by column.

bensimpsy_0-1712651446185.png

This then sorted the columns in the Chronological order.

bensimpsy_2-1712651651608.png

Hopefully this helps someone in future.

Idrissshatila
Super User
Super User

Hello @bensimpsy ,

 

yes, you can sort the month name by the month number in the data view.

 

check this out https://youtu.be/NlX7Cp2P0d4?si=7lyMiYXCuiSVDnZc

 



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




Thanks for the reply, however I am using the Power BI Service (app.powerbi.com) not the Desktop App and this same approach doesn't seem to apply.

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors