Reply
avatar user
Anonymous
Not applicable
Partially syndicated - Outbound

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

rohit1410_0-1620652202115.png

I need to dynamically select the legends. And accordingly the chart should change.
Expected result - 

rohit1410_2-1620652868857.png


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 

 

1 ACCEPTED SOLUTION
v-yiruan-msft
Community Support
Community Support

Syndicated - Outbound

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

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-yiruan-msft
Community Support
Community Support

Syndicated - Outbound

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

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
avatar user
Anonymous
Not applicable

Syndicated - Outbound

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

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

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

March2025 Carousel

Fabric Community Update - March 2025

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

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