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, get a free DP-600 exam voucher to use by the end of 2024. 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
November Carousel

Fabric Community Update - November 2024

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

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

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