topic Re: Dynamically add value columns to a line chart in DAX Commands and Tips

Dynamically add value columns to a line chart

kitti — Mon, 20 Jul 2020 04:00:10 GMT

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,

Re: Dynamically add value columns to a line chart

amitchandak — Mon, 20 Jul 2020 04:06:19 GMT

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

Re: Dynamically add value columns to a line chart

kitti — Mon, 20 Jul 2020 04:32:31 GMT

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,

Re: Dynamically add value columns to a line chart

amitchandak — Mon, 20 Jul 2020 04:55:38 GMT

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/