filtering legends of the line chart or any other visual

[Anonymous]

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 

[v-yiruan-msft · Accepted solution]

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

Power BI Dynamic Legend

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

[Anonymous]

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