Dynamically add value columns to a line chart

[kitti]

Hi experts,

I want to have a line chart (control chart) that dynamically have values line based on filtered data.

For instance, I have my data like this below but I want to show 2 lines of value because I filtered 2 parameters so it should show a line per each parameter

I also found a cool way of doing that from youtube but I am still perplexed because my data has a bunch of parameters (100+) that can be filtered. So, I think it might not work for me.

https://www.youtube.com/watch?v=OIGGrrnMIgk

any suggestion would be appreciated

Thank you,

KL

[amitchandak]

@kitti , I think to have new line with a selected parameter, when you have that parameter in legend ?

[kitti]

@amitchandak 

Thanks for your reply. I knew that but if I use legend, I cannot have more than 1 column on the Values box which I want to add several columns there like usl, lsl, target, value data in the screenshot

Regards,

KL

[amitchandak]

@kitti , you will not be able to add additional measures. Only thing you do show hide lines already exiting lines. Means you have add them beforehand. And just show hide based on value.

you may have to use: https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/