Forum Discussion
Grouping records dynamically in matrix visual
Hi! I'm trying to create a matrix that uses a measure that changes with a date slicer selection. Currently, I only have the matrix grouped by whatever the table calculated for the day. I want to g...
amitchandak
Super User
Super UserviewSonic123 , if unit is sum of unit or a measure then you need
then you need
Dynamic Segmentation Bucketing Binning
https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-Segmentation-Bucketing-Binning/m-p/1387187#M626
Dynamic Segmentation, Bucketing or Binning: https://youtu.be/CuczXPj0N-k
Else you can use a switch
a new column
= Switch(true() ,
[Unit]<5, " 0-5",
[Unit]<10, " 5-10",
// add other
"More than 10" )
Will try these out and let you know. Thanks!
