- 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

filtering legends of the line chart or any other visual
hi all,
Need help for the following 2 requirements -
1. I have a line chart with multiple legends. The legends (forecast, production plan etc) are taken from different tables. And the x axis is calendar axis having joins with different tables used as legends
Screenshot below
I need to dynamically select the legends. And accordingly the chart should change.
Expected result -
2. I have a measure that calculates Projected Inventory (PI) = Production plan - Forecast.
It should calculate PI based on what I select at the filter.
If I select only Forecast, then PI formula should return ----->Forecast.
If I select Forecast and Production plan, then it should return --->Production plan - Forecast.
Can I have the logic for the same.
let me know if you want any more inputs.
thanks for helping
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi @Anonymous ,
Could you please provide some sample data (exclude sensitive data) from the involved tables in the line chart and your expected result with specific examples and the related logic in order to provide you a suitable solution? Thank you.
On the other hand, please review the content in the following links and hope they can help you.
1. Dyanamic legend
DYNAMIC LEGEND IN #POWER BI VISUAL, LINE CHART
Dynamically filter legends in a chart based on selection from other chart
2. Dynamic calculation base on slicer selection
DAX - Column content based on slicer selection
Best Regards
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi @Anonymous ,
Could you please provide some sample data (exclude sensitive data) from the involved tables in the line chart and your expected result with specific examples and the related logic in order to provide you a suitable solution? Thank you.
On the other hand, please review the content in the following links and hope they can help you.
1. Dyanamic legend
DYNAMIC LEGEND IN #POWER BI VISUAL, LINE CHART
Dynamically filter legends in a chart based on selection from other chart
2. Dynamic calculation base on slicer selection
DAX - Column content based on slicer selection
Best Regards
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@v-yiruan-msft Thanks a lot for providing the relevant links😀. Those really helped

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
08-22-2024 12:04 PM | |||
10-24-2024 09:13 AM | |||
11-13-2024 12:34 AM | |||
07-04-2024 04:00 AM | |||
08-29-2024 07:12 PM |
User | Count |
---|---|
137 | |
107 | |
85 | |
59 | |
46 |