Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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
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
@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/
User | Count |
---|---|
11 | |
11 | |
8 | |
6 | |
5 |
User | Count |
---|---|
25 | |
19 | |
16 | |
10 | |
7 |