cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

Top 20 Slicer

I am trying to build a Top 20, 50 and 100 slicer that slices the Visual: "Room Revenue by Account 2020" by Room Revenue. I know how to apply this filter in the visual level filters, but i don't know how to make it into a slicer. Please Help

a.jpg

1 ACCEPTED SOLUTION

Accepted Solutions
vaibhavdesai Established Member
Established Member

Re: Top 20 Slicer

Hi,

Here's the new link. Refer Page 1 in the report.

https://1drv.ms/u/s!AikPceQOhqFEhAtqF3aCT5lgHBoQ?e=kf2j9m

Thanks.

View solution in original post

5 REPLIES 5
vaibhavdesai Established Member
Established Member

Re: Top 20 Slicer

Hi,

Below is the link for a sample report created for your requirement.

https://1drv.ms/u/s!AikPceQOhqFEhAmSHMhdM7U5LjGB?e=uqAxFJ

Thanks.

Super User
Super User

Re: Top 20 Slicer

Hi,

Why do you want a slicer when you can get the same result with a simple built-in filter setting?


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Re: Top 20 Slicer

The link for the attached file you sent doesn't work, it says the file no longer exists. Can you help me with this?. Also, I need a slicer because my teams wants a tool that is more user friendly for the report.

vaibhavdesai Established Member
Established Member

Re: Top 20 Slicer

Hi,

Here's the new link. Refer Page 1 in the report.

https://1drv.ms/u/s!AikPceQOhqFEhAtqF3aCT5lgHBoQ?e=kf2j9m

Thanks.

View solution in original post

Re: Top 20 Slicer

Thank you very much! This was exactly what i was trying to implement in my own report.

Helpful resources

Announcements
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 335 members 2,956 guests