Conditionally Format Sparkline Column (or any alternative solutions)

[mthomas1973]

Hello. 

I am in the process of creating a dashboard and a visual that my customers like is something that shows the last 6 periods status (i.e. was performance on target, etc...).

One of the ideas I was exploring was a sparkline column but I want to conditionally format the markers for different statuses. 

I can't see how to do that -- is there a way? Or another way of showing the last N periods with a different marker for each period depending on the status. I have done something in a different format using a scatter plot but I want a view in a table like the one above. 

Any thoughts??

[lbendlin]

I would recommend to use SVG for this instead. Much more flexible.

[mthomas1973]

Thank you, I appreciate the help. Is there any resource you would recommend for learning about using SVG ? Not something I have done before. 

[lbendlin · Accepted solution]

here's a good starter

SVG Sparklines - Line - Microsoft Power BI Community

[mthomas1973]

Interesting link, thank you -- something for me to have a play with!