Forum Discussion
Tracking changes month on month with multiple results!!
Hello there!
I believe one of this visuals way of representing the data could be of use in your case?
Take into account im considering each "Stream" as a project, and modified the input a bit to have 3 or 4 months of data.
You can also have text (I choose to hide it) and of course it need a lot more work to look nicer, but any of this would help users track which "colours" were set for each project each month.
Tell me if something like this would work, or you need something else I might have misunderstood.
Just as a heads up, I will be more detailed if need be, I unpivoted the 4 initial color columns to an attribute-value pair, then created the matrixes above and set conditional fomatting to background and font color.
Thank you, that's helpful.
After posting here, I tried a similar approach where I wrote individual measures and added them as columns to the matrix, then conditionally formatted them according to color.
The issue I'm facing is that the client wants to know exactly what has changed and when. While the matrix provides this information, they want to see at a glance if there has been a change, such as a color moving from amber to red, green to red, red to green, etc. Essentially, they want all possible outcomes mapped and to be notified of which change has taken place.
They have also asked if they could get a count of the types of changes in the month. I need a way to tell them what the previous color was and what it is now. Are you able to provide a measure that brings back the selected month's colors in a card visual and then shows what the previous color was? So far, I have only been able to bring out the latest colors and one month prior