Forum Discussion
Measures into Columns - Dynamic Grouping based on window context problem
Anonymous , You can not create a calculated column. You need to create and independent table and do segmentation
refer if my viedo or these atricles can help
https://www.youtube.com/watch?v=CuczXPj0N-k
Segmentation
https://www.daxpatterns.com/dynamic-segmentation/
https://radacad.com/grouping-and-binning-step-towards-better-data-visualization
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?
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
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!