cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

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
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

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

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors