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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

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

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.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

Top Solution Authors