Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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
Solved! Go to Solution.
Hi @JM_CORP ,
Based on the description, please try the following methods:
1.Create the new column for sorting.
2.Select the new column and sort from Z to A.
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.
Thank you for the alternative, it works for me
Hi @JM_CORP ,
Based on the description, please try the following methods:
1.Create the new column for sorting.
2.Select the new column and sort from Z to A.
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.