Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Jartiv
New Member

Slicer sorted by date

So I have a sheet that collects project updates... 3 columns - Project Name, Note, Date Entered

I'd like to have a slicer to select projects by name but have the projects ordered based on date entered - a project with the most recently entered note would be at the top.

Any suggestions on how I might approach this? 

1 ACCEPTED SOLUTION
v-piga-msft
Resident Rockstar
Resident Rockstar

Hi @Jartiv,

 

By my test, you could follow the steps to get what you want.

 

1. Go to Date view——Modeling——Click Product Name ——Sort by Column——Date

 

Untitled.png

 

2. Go to Report View——Create the Slicer with Product Name.

 

Untitled1.png

Hope it can help you!Smiley Tongue

 

Best Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
v-piga-msft
Resident Rockstar
Resident Rockstar

Hi @Jartiv,

 

By my test, you could follow the steps to get what you want.

 

1. Go to Date view——Modeling——Click Product Name ——Sort by Column——Date

 

Untitled.png

 

2. Go to Report View——Create the Slicer with Product Name.

 

Untitled1.png

Hope it can help you!Smiley Tongue

 

Best Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hardik
Continued Contributor
Continued Contributor

Screenshot_3.pngI hope this helps

Sorting in the editor doesn't affect the order in your PivotTable. Please just give it a try and add a slicer for Project Name.

It should be ordered alphabetically.

Floriankx
Solution Sage
Solution Sage

Hello,

 

usually the slicer sorts by the value in the column you slice. Meaning, text slicers should be ordered alphabetically on default.

You also can sort them by another column if you want a different order.

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.