Good day!
I come to you with perplexing query that has fell onto my lap and I need some advice:
The requirements of this 'visual' are as follows:
- The matrix is a fixed grid. A fixed heatmap with colors ranging from red, yellow to green.
- The X-axis and Y-axis value represent the severity of the colors, so imagine brighest green being top right (the good stuff) and darkest red being bottom left (really bad stuff). Yellows will go diagionally from top left to bottom right.
- Items, reprented as their name or as a visual, are to fill in each square on the grid; reflecting on where they sit on the really bad to really good range.
- E.g. if two items are really bad, they will both show in the bottom left square of the heatmap.
- Both current month's data and previous month's data is to be seen. This will highlight any movement with items.
- Previous month's data needs to show as faded.
- An arrow needs to show between the previous month's position on the grid and the current month's position, if a item has changed position between the months.
For everything (excluding the arrows), the current thinking is that this can be possible with measures and having cards represent the different grid positions on the static heatmap. Possibly having a second layer of cards on top to help show previous month's results, or using this multi layer approach with other visuals.
The hair-tearing part comes with the arrows. The arrows are needed; and to my current knowledge, it is not possible to do it without some extensive programming skill.
So the query is, is there a way to show moving arrows between one visual data point to another, based on the above visual needed?
If an existing visual exists, brilliant! If not, any pointing to similar queries, even ones that use Python or using other O365 components in the PowerBi report (e.g. Visio), will be brilliant.
Overall, a fresh view on this problem and any help will be immensely appriciated.
