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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

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
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! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

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