Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Anonymous
Not applicable

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

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

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.
Anonymous
Not applicable

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

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.