conditionally color the cells of a matrix

[alihijazi]

Hello

Got a matrix that shows by Sales man and by Year the sales and the percent of change in sales between year and the previous one

what I want is to color the percent of change in red in case the difference was negative

something like the following:

how to accomplish this?

Please advise

[asocorro]

While it's a different type of visualization, you might want to try the Tadpole Spark Grid Plus for a similar effect:

This visualization draws a grid (using Matrix data) of spark lines which have a particular color scheme.   The line segments are colored (black-positive) and (red-negative) based on a comparison of the current period value with the previous period value.

Check it out in the Custom Visuals Gallery: https://app.powerbi.com/visuals/.

[kwchung00]

Seems I don't see Tadpole Spark Grid Plus available in the custom visuals.  I used the previous version I downloaded long ago, but seems not working.  Is there any alternative charts?

[Sean]

Yes coming this spring... Screenshots from the Presentation...

[Mykhael]

Finally!!! (y)

[Mi2n]

This feature is announced in the MS Data Insight summit and should be available in the spring. You can see the opening keynote presentation from the below link.

https://www.youtube.com/watch?v=jH7BVpVMsEw

watch from 58th minute.

[Iheb_Ghali]

but this is only available on tables!!  can we do it on matrix???

i also realized that this couldn't be done on calculated measures within the matrix is that right??

thx 

[Anonymous]

Hi @alihijazi,

   I think that for now you cannot do this.

But if you want you can vote here to make this real.

#I'M Not An Expert#