- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

how to add 'year' drop down filter in line chart
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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! | |
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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?

Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - February 2025
Check out the February 2025 Power BI update to learn about new features.

Subject | Author | Posted | |
---|---|---|---|
01-02-2024 08:52 AM | |||
05-28-2024 09:28 AM | |||
05-29-2024 09:01 PM | |||
05-06-2021 11:48 PM | |||
04-08-2024 03:22 AM |
User | Count |
---|---|
84 | |
81 | |
52 | |
37 | |
36 |