
Brandon Kinzel
Active Member
Members
Dashboards
Power Query
Power Pivot
Dashboards
Power Query
Power Pivot

Forum Posts: 4
Member Since:
February 20, 2022
February 20, 2022

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.

Brandon Kinzel
Active Member
Members
Dashboards
Power Query
Power Pivot
Dashboards
Power Query
Power Pivot

Forum Posts: 4
Member Since:
February 20, 2022
February 20, 2022


Jessica Stewart
Northern USA
Member
Members

Trusted Members

Trusted Members

Forum Posts: 202
Member Since:
February 13, 2021
February 13, 2021


Riny van Eekelen
Örnsköldsvik, Sweden
Moderator
Members

Trusted Members
Moderators
Power BI

Trusted Members
Moderators
Power BI

Forum Posts: 440
Member Since:
January 31, 2022
January 31, 2022


Mynda Treacy
Admin

Forum Posts: 4439
Member Since:
July 16, 2010
July 16, 2010

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
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online:
Guest(s) 10
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 870
Purfleet: 412
Frans Visser: 346
David_Ng: 306
lea cohen: 219
A.Maurizio: 202
Jessica Stewart: 202
Aye Mu: 201
jaryszek: 183
Newest Members:
Ivica Cvetkovski
Blaine Cox
Shankar Srinivasan
riyepa fdgf
Hannah Cave
Len Matthews
Kristine Arthy
Michelle Neven
Andrew Kuhn
Angela Paul
Forum Stats:
Groups: 3
Forums: 24
Topics: 6206
Posts: 27202
Member Stats:
Guest Posters: 49
Members: 31875
Moderators: 3
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: MOTH Support, Velouria, Riny van Eekelen
© Simple:Press —
