Forum Discussion
PowerBI Matrix Visual: Sparklines with conditional formatting
Hello Power BI Comunity,
I'm trying to convince my team to change to power bi, but one of the demands is to have a matrix with sparklines conditionally formatting. In this sparklines as columns i will have the last 12 months and when its negative i need to paint it in red and when it's positive to paint it in Blue or Green. I tried already some workarrounds but i wasn't abble to get to a working solution. I even try some imported visuals but or i can't do the conditional formatting in the sparkline or in the value columns.
The Sparkline should be more a less like this:
Thank you in advance
Hi karl05
Zebra custom visual might have some of these features, but there might be a costing involved or those. But this can be acheived using SVG. Below video will get you started.
https://www.youtube.com/watch?v=QOcP5OvSwlI&t=890s
basically you create a svg bar chart( one that works for your need with dynamic formattin) then use that in the matrix. This might look complex but a intresting thing to learn.
Let me know if you have any questions or ideas to implement it.
If this post helps, then please consider Accept it as the solution to help the others find it more quickly. Appreciate you kudos!!
Follow me on LinkedIn!!!
1 Reply
Hi karl05
Zebra custom visual might have some of these features, but there might be a costing involved or those. But this can be acheived using SVG. Below video will get you started.
https://www.youtube.com/watch?v=QOcP5OvSwlI&t=890s
basically you create a svg bar chart( one that works for your need with dynamic formattin) then use that in the matrix. This might look complex but a intresting thing to learn.
Let me know if you have any questions or ideas to implement it.
If this post helps, then please consider Accept it as the solution to help the others find it more quickly. Appreciate you kudos!!
Follow me on LinkedIn!!!