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 September 15. Request your voucher.
I have a matrix where the columns across the top are a calculated column for Month.
The data is displaying is correct, but I would like to reverse the sort order for the columns. Instead of displaying from left (oldest) to right (newest), I would like the newest data to display at the far left and oldest data at the far right. Changing the sort on column headings is very easy to do in Tableau, but I can't figure it out in Power BI.
Thanks for any suggestions!!
Hello @TLW_STL ,
Yes, you just sort by this column but descending.
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Proud to be a Super User! | |
Idrisshatila, my columns are not a date field. They are a calculated column. I do not have an option to sort the dates in descending. Enclosing screen shot.
Please provide your work-in-progress Power BI Desktop file (with sensitive information removed) that covers your issue or question (not as a screenshot).
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.
https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...
This allows members of the Forum to assess the state of the model, report layer, relationships, and any DAX applied.
Foodd, I uploaded my example file. Here is the link.
Thanks!
User | Count |
---|---|
65 | |
60 | |
55 | |
54 | |
31 |
User | Count |
---|---|
180 | |
88 | |
70 | |
46 | |
45 |