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

Preparing for a certification exam? Ask exam experts all your questions on May 15th. Register now.

Reply
lisratkoceri
Frequent Visitor

Drop down option

dropdownproblem.png

 

Hi community can someone help me on how do i create a drop down menu like this on a visual that lets me choose different values i want to see and compare. Thanks

8 REPLIES 8
lisratkoceri
Frequent Visitor

Hi when i try to create the slicer i dont get the list for example like yours with the product line i get mine with values like this resultsss.png

Pragati11
Super User
Super User

Hi @lisratkoceri ,

 

You can add a slicer visual to your report page to get this done. I made the slicer single select.

Pragati11_1-1692091233937.png

 

Pragati11_0-1692091121436.png

Then you can use this slicer visual to interact with your chart:

PBI tip.gif

Hope this helps.

 

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

Im still having this problem down below i posted it as a comment didnt know i wasnt replying

Hi @lisratkoceri ,

 

Make sure you have single selection selected under the slicer settings:

Pragati11_0-1692100428602.png

 

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

powerbihelppp.png

Still getting the same results

Hi @lisratkoceri ,

 

I don't know what data you are looking for. You are moving a numeric column to the slicer now. Try moving a categorical column from your data.

May be Paid/Organic column as per your screenshot about the data.

 

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

Yes that may be the case since im trying to filter numeric values

Hi @lisratkoceri ,

Yes try using categorical column and also check your requirement what you really want.

 

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

Helpful resources

Announcements
PBIApril_Carousel

Power BI Monthly Update - April 2025

Check out the April 2025 Power BI update to learn about new features.

Notebook Gallery Carousel1

NEW! Community Notebooks Gallery

Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.

April2025 Carousel

Fabric Community Update - April 2025

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