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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
SachinC
Helper V
Helper V

Is there a dropdown instead of slicer?

Hi,

I am reporting on a table with no relationship.  Is there a way of having a drop-down instead of a slicer?

Thanks!

4 ACCEPTED SOLUTIONS
chrisu
Responsive Resident
Responsive Resident

There isn't an official one yet, but there is a custom visual called "Smart Filter" that provides drop-down functionality.  See http://okviz.com/smart-filter/

View solution in original post

The is also an idea that you should vote for to get it.

/sdjensen

View solution in original post

@SachinC@chrisu@sdjensen Another option: With yesterday's release there is now the option to search a slicer. This shortcuts the need to scroll and allows you to select specific values. You can click on the elipses of the slicer -> search type in what you are looking for -> check -> clear search and keep repeating. Works very well.

 

May not be what you are looking for, but it is native and looks like it does the same thing as the custom viz in principle.

 

(Get latest June Desktop update to see this feature)


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

View solution in original post

v-qiuyu-msft
Community Support
Community Support

Hi @SachinC,

 

In the Power BI desktop, we can use Query Parameters to filter report data. We can specify a list of the values for query parameter in Query Editor. When we run the report, we can check different values from the list to perform filter. See:

 

a2.PNGa1.PNG

 

Reference:

Deep Dive into Query Parameters and Power BI Templates

 

If you have any question, please feel free to ask.

 

Best Regards,
Qiuyun Yu

 

 

Community Support Team _ Qiuyun Yu
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-qiuyu-msft
Community Support
Community Support

Hi @SachinC,

 

In the Power BI desktop, we can use Query Parameters to filter report data. We can specify a list of the values for query parameter in Query Editor. When we run the report, we can check different values from the list to perform filter. See:

 

a2.PNGa1.PNG

 

Reference:

Deep Dive into Query Parameters and Power BI Templates

 

If you have any question, please feel free to ask.

 

Best Regards,
Qiuyun Yu

 

 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
chrisu
Responsive Resident
Responsive Resident

There isn't an official one yet, but there is a custom visual called "Smart Filter" that provides drop-down functionality.  See http://okviz.com/smart-filter/

The is also an idea that you should vote for to get it.

/sdjensen

@SachinC@chrisu@sdjensen Another option: With yesterday's release there is now the option to search a slicer. This shortcuts the need to scroll and allows you to select specific values. You can click on the elipses of the slicer -> search type in what you are looking for -> check -> clear search and keep repeating. Works very well.

 

May not be what you are looking for, but it is native and looks like it does the same thing as the custom viz in principle.

 

(Get latest June Desktop update to see this feature)


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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