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?
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/.
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?
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.
watch from 58th minute.
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??
Check out the News & Announcements to learn more.
Congratulations, the new Super User Season 2 for 2021 has started!
Check out the new Power Platform Community Connections gallery!
Mark your calendars and join us for our next Power BI Dev Camp!