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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
JM_CORP
Regular Visitor

Sort date segment when I use analysis in excel of a pbi cube

Hello, 

 

I have uploaded a power bi cube on pbi service and I use analysis in excel function to build some reports on excel.

In order to filter my data, I use a Date segment from the field Date of my Calendar table.

 

When I try to sort my segment from Z to A to have latest dates on the top, it's sorting my segment as "Date" field was a text format. In power bi I have defined it as a Date format.

 

I know that everything different of measures are treated as text format in a pivot table connected to power bi datamodel. 

Is there any solution to be able to sort my Date segment from latest date (Z to A).

 

Thanks in advance for your help.

 

Best regards

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @JM_CORP ,

Based on the description, please try the following methods:

1.Create the new column for sorting.

vjiewumsft_0-1724313093993.png

2.Select the new column and sort from Z to A.

vjiewumsft_1-1724313108599.png

3.Refresh the data in the excel.

 

Best Regards,

Wisdom Wu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
JM_CORP
Regular Visitor

Thank you for the alternative, it works for me 

Anonymous
Not applicable

Hi @JM_CORP ,

Based on the description, please try the following methods:

1.Create the new column for sorting.

vjiewumsft_0-1724313093993.png

2.Select the new column and sort from Z to A.

vjiewumsft_1-1724313108599.png

3.Refresh the data in the excel.

 

Best Regards,

Wisdom Wu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.