Forum Discussion
Double grouping in visuals (no Power Query)
Hi there, how would one solve this sort of problem?
I want to have a filtered visual for the following:
DATA
| Clowns | Balls | Color |
| ClownA | 1 | Red |
| ClownB | 2 | Blue |
| ClownC | 3 | Green |
| ClownD | 4 | Green |
| ClownE | 4 | Yellow |
| ClownF | 4 | Red |
| ClownG | 2 | Red |
| ClownH | 2 | Blue |
| ClownI | 1 | Red |
| REPORT & VISUAL | ||
| Desired output (available filter: Color) | ||
| # of Clowns with 1 Ball | 2 | |
| # of Clowns with 2 Balls | 3 | |
| # of Clowns with 3 Balls | 1 | |
| # of Clowns with 4 Balls | 3 |
Not sure how you'd call this sort of "binning", but this is the desired logic.
I want to be able to tell how many clowns are in each category, with the data being filterable by color.
In other words, when applying a red color filter, the output will indicate the # of clowns with red balls, within each category.
Ideally, I want to achieve this without the use of a power query, as I am dealing with a massive amount of data and several other calculation, as well as remote data...
No matter what, it must be possible to plot a graph that plots the result as per the output table above, impacted by a color filter.
Thanks in advance,
Eugen
Hi,
PBI file attached.
Hope this helps.
My solution will not be affected by an additoinal Date column in Table1.
17 Replies
Hi,
PBI file attached.
Hope this helps.
Thank you very much.
Almost there, but how can this be done if the # of categories has to be dynamic and potentially much higher (in the tens)? Obviously that would not be colors, as in this example. Let's say that it's numbered balls... But at the beginning we don't know what's the max # of categories that we will have at the beginning of the calculation.
Thoughts? In reality, in my real life case it looks like I will have 14 categories, but I'd like to know how to handle this if that changes a lot, as it looks like it may.
Thank youYou are welcome.
Ah, never mind, that's over complicating it.
I'm sure that I won't need to make that upper limit dynamic after all.Thanks again. This works.
So, the idea is that the clowns get their balls in batches, at different times, not all at once.
