Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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/
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
22 | |
7 | |
6 | |
6 | |
6 |
User | Count |
---|---|
27 | |
10 | |
10 | |
9 | |
6 |