Reply
avatar user
Anonymous
Not applicable
Partially syndicated - Outbound

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

Syndicated - Outbound

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!




avatar user
Anonymous
Not applicable

Syndicated - Outbound

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

 

avatar user

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!

FebPBI_Carousel

Power BI Monthly Update - February 2025

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

Feb2025 NL Carousel

Fabric Community Update - February 2025

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

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)