cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
alihijazi
Helper I
Helper I

conditionally color the cells of a matrix

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:

conditional_formatting.png

 

how to accomplish this?

Please advise

8 REPLIES 8
asocorro
Skilled Sharer
Skilled Sharer

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/.

 

 

Connect with me in LinkedIn: https://pr.linkedin.com/in/adolfosocorro
Follow me on Twitter: https://twitter.com/AdolfoSocorro

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
Community Champion
Community Champion

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

image1.PNGimage2.PNG

Finally!!! (y)

Mi2n
Microsoft
Microsoft

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.

 
// if this is a solution please mark as such. Kudos always appreciated.

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 Smiley Happy

B129
Continued Contributor
Continued Contributor

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#

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!