Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more
Hi,
I'm fairly newbie in Power bi, I have a table like this,
and I just want to add a drop down list in the line chart to filter the data for each year, how to achieve this? can anybody advise, thanks
Hello,
you could add a slicer having the years
and to make it a drop down list you do like in the screenshot
If I answered your question, please mark my post as solution so it would appeare to others, Appreciate your Kudos👍
Proud to be a Super User! | |
Thank you for the prompt answer. I tried slicer and it works, just one more silly question,
I change the slicer background color to black and the font color is white, but the color of the selected icon didn't change, I want it to be white too, how to achieve this?
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.