The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
User | Count |
---|---|
36 | |
15 | |
12 | |
11 | |
9 |
User | Count |
---|---|
45 | |
44 | |
19 | |
18 | |
18 |