I recently had this type of request at work – stop me if you’ve heard this before. We need to show the trend of [single or multiple measures] and we want to see it by these specific dimensions. Oh! And we also need to be able to filter by the same dimensions as well…
“Sure! No problem” you say because why would you turn down a challenge? But then you start building it and you realize that these dimensions have a hard cardinality so the trends turn into a plate of spaghetti. This is obviously not ideal so you have to get creative – and this is what I end up building to satisfy the request.
This solution allows them to do everything wanted, presented in a practical solution and forces THEM to decide to look at a spaghetti chart if that’s what they choose.