cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
pgeorges
Frequent Visitor

Conditional Format only ONE data marker line - CONTROL CHARTS

Hi There,

 

I'm trying to build a control chart where I want to add a red dot as a data marker to any value beyond the control limits (red dashed lines). I was able to do this by doing the conditional formatting on a bar chart and then changing it to a line chart. When I added more lines to the graph, such as the control limits and mean, the conditional formatting affected both those lines too. How can I add conditionally formatted data markers on only the black line?

https://photos.app.goo.gl/Q95n7bFwpvu9zcrt9

 

Thanks for your help in advance,

 

Peter

8 REPLIES 8
pgeorges
Frequent Visitor

No worries. Thanks for your quick responses!

parry2k
Super User III
Super User III

@pgeorges not sure what else to tell, I tied. good luck with a custom visual. 😑






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





parry2k
Super User III
Super User III

@pgeorges you can add a control line from the analytical pane, try that and see if doesn't show these conditional formatting. Again you have to test it.






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





pgeorges
Frequent Visitor

Great suggestion! However, it still didn't work 😞 It now puts it above the red marker... which is slightly better than before, I guess.

pgeorges_0-1610039193502.png

 

parry2k
Super User III
Super User III

@pgeorges just curious how you are under upper/middle/lower control lines? Did you created measures for it or using the Analytic pane from the line visual?

 

PS: I hardly use custom visuals, unfortunately don't know if there is one that already exists, you need to check by yourself.






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





pgeorges
Frequent Visitor

I created measures for it.

parry2k
Super User III
Super User III

@pgeorges I'm afraid there is any solution for it.






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





pgeorges
Frequent Visitor

Are there at least any free power bi visuals to replicate a control chart? The ones I see seem to only have a paid subscription...

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors