Log In
Register
Home
Active Member
Dashboards
Power Query
Power Pivot
February 20, 2022
Offline
Hi, I am creating a dashboard for our executive team and I am running into an issue. I have a pivot table linked to slicers and I want the 2023 revenue to be sorted from largest to smallest. You will see in pic 1, that it is sorted that way but when I click on aother business unit in the slicer it doesn't sort that way (pic 2). Any help would be greatly appreciated.
Active Member
Dashboards
Power Query
Power Pivot
February 20, 2022
Offline
Trusted Members
February 13, 2021
Offline
In this case, it would be helpful if we could see a sample of the file so we can look at the settings of your pivot tables.
Trusted Members
Moderators
Power BI
January 31, 2022
Offline
Please try to upload the picture (or better a file) again. Don't forget to press "Start upload" before you submit your reply.
October 5, 2010
Offline
Hi Brandon,
We're happy to help you but please don't post the same question in more than one of our forums, it just makes more work for everyone either replying to you, or me having to tidy up and delete one of the duplicates.
Thanks
Phil
July 16, 2010
Offline
Hi Brandon,
In the absence of a sample file and Pic 1, which wasn't attached, perhaps this tutorial on how to sort in PivotTables will explain the issue you're having and the solution.
If you're still stuck, please share the file or an anonymised sample file.
Mynda
Active Member
Dashboards
Power Query
Power Pivot
February 20, 2022
Offline
It won't let me upload the file. It exceeds the size allowed. Below is another pic that may help. I want to sort by 2023 revenue, which is correct in this picture but when I click on another business unit (Media, digital, etc.) it loses the way it is sorting.
1 Guest(s)
