DAX Measure for Conditional Color for Sparklines (SVG format)

[swasim]

Hi ,

Need help from experts , my client requirements

1) Draw a Sparkline using SVG  (Was able to get done)

2) Based on selected Date Filter , Sparkline should be charted for last 4 quarters. (Was able to get done)

3) Client wants to change Line color using  Linear Gradient based on the condition (Result Field )(I am having difficulty and need help)

If Value of Result is good  then  "#178757"  --green

If Value of Result is Bad then "#D71e28"   --red

if Value of Result is Aver then "#FFD100"  --Yellow

Attached the actual PBIX file and data for your reference. Can someone help here , having difficulty is drawing Line colors.

https://drive.google.com/file/d/1W2es4HwI58VUvLvgAkqTfWOwx693PCIz/view?usp=sharing

https://docs.google.com/spreadsheets/d/1N1JbmWC3eUrzl7iMLcFJ5Y1nQ-LWeVfO/edit?usp=sharing&ouid=10982...

My reference for above chart i using below links.

https://kerrykolosko.com/portfolio/gradient-sparklines/

https://community.fabric.microsoft.com/t5/Desktop/Dax-for-SVGImages-sparkline/td-p/1092683

[lbendlin]

Gradients are defined a little different than your sample code.

Gradients in SVG - SVG: Scalable Vector Graphics | MDN (mozilla.org)

VAR Defs = "<defs>
    <linearGradient id='grad' x1='0' y1='25' x2='0' y2='50' gradientUnits='userSpaceOnUse'>
        <stop stop-color='green' offset='0' />
        <stop stop-color='yellow' offset='50%' />
        <stop stop-color='red' offset='1' />
    </linearGradient>
</defs>"

[swasim]

Yes , i dont know . Th Gradients i just copied from internet and i dont know how to resolve.  how do we pass to the PBI sparkline based on condition. 

I dont want this hardcoding. Line color should be based on the condition in the excel.

<stop stop-color='green' offset='0' />
        <stop stop-color='yellow' offset='50%' />
        <stop stop-color='red' offset='1' />

Its based on the color from excel. Already based on the condition the color coding is in the excel.

[lbendlin]

Your conditions change over time. That means you cannot use lines for the coloring, you would need to use single dots and color these accordingly.

[swasim]

Could you update the PBIX file and send me.

[lbendlin]

No, you need to rethink your approach.  A common visual for your scenario could be a box and whiskers scatter plot, or a Deneb custom visual.

[swasim]

THis is rough sketch.  I am looking at solution like this for last 4 quarters with different line colot. Is this possible ? 

[lbendlin]

yes, that is possible, but I don't see how this would be useful to your report users.