Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi all,
I connect to one of my reports via Excel and create a pivot table using the Power BI dataset.
One of the columns I am using in pivot table conatins dates.
I would like to sort the dates from the newest to the oldest.
The issue is that the Excel reads these dates as text and I can only sort it ascending or descending which gives me wrong results.
The column data type in report is set to "Date".
Formating cells in Excel doesn't work.
Is there a way to change this column's format in Excel so it sorts properly?
Wrong outcome:
Desired outcome:
It is set to sort by date.
Screenshot is in Polish but it says it sorts descending by date.
User | Count |
---|---|
131 | |
74 | |
70 | |
58 | |
53 |
User | Count |
---|---|
190 | |
97 | |
67 | |
62 | |
54 |