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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.