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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more

Reply
Anonymous
Not applicable

how to add 'year' drop down filter in line chart

Hi,

 

I'm fairly newbie in Power bi, I have a table like this, 

Kelvin04_Zou_1-1671627891751.png

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

Kelvin04_Zou_2-1671628022082.png

 

 

 

 

2 REPLIES 2
Idrissshatila
Super User
Super User

Hello,

 

you could add a slicer having the years

Idrissshatila_0-1671628670907.png

Idrissshatila_1-1671628710457.png

 and to make it a drop down list you do like in the screenshot

Idrissshatila_2-1671628756170.png

 

If I answered your question, please mark my post as solution so it would appeare to others, Appreciate your Kudos👍

Follow me on Linkedin



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




Anonymous
Not applicable

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? 

Kelvin04_Zou_0-1671721222128.png

 

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors