Day 3, and I've got a collection of scatter plots, all checking for correlations between pairs of five variables. Ideally, I'll click on a point on one of them, and it'll highlight the relevant point in the others as well, maybe fading out the rest, or changing it to a different colour. Can I do that in Power BI? Nope, it's filter them out or nothing, oh well. Guess instead I'll just duplicate the charts (FIFTEEN of them), turn off interactions, make them lighter colours and put them underneath.
Can I use a parameter to change the measurement on the charts, so they're going from slightly jittered (to prevent dots being on top of each other) to exactly on point? Nope, have to rebuild all the charts (once again, FIFTEEN) and use a bookmark.
Speaking of the slightly randomised numbers, by the way, can I take that variable off the tooltip and only have the precise one? No, guess I'll just have to take what it gives me, it's ugly but this is one there really is no way round. Or maybe I could put a value for the trend line in the tooltip as well? Ah, no, have to work that out manually and add it in a new field, that's a sensible workaround.
And, so ends the moan. Sorry about that.