Forum Discussion
Anonymous
5 years agoNot applicable
Measures into Columns - Dynamic Grouping based on window context problem
I have a dataset that I'd like to visualize with a dynamic legend - taking the groups with the 7 max individual values in my window context, showing them as they are, then grouping the rest into one ...
Anonymous
5 years agoNot applicable
amitchandak thanks, i've seen videos like this and where I get stuck is on the hardcoding of bins. I need dynamic bins, with the top 7 values in any given window context, not a reference to a table that has set bin values. Is this doable?
amitchandak
5 years agoSuper User
Anonymous , See if this can help: https://community.powerbi.com/t5/Desktop/Top-5-and-others/td-p/165945
I will also try to check
- Anonymous5 years agoNot applicable
amitchandak thanks, this link appears to calculate top values via a measure, which is certainly doable but as you know not usable in a legend. You can see my problem!