March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
So I've measures of particular stores like YoY Growth and MoM growth in my dashboard , now I want to put them into slabs
Growth > 0 , 0 to -10 , -11 to -50 , -50
I'm struggling to put them into respective slabs
If statements just result in tagging them as positive or negative, I also tried switch statements . I also want the count of the stores falling in the respective slabs
I tried this dax but this doesn't seem to work, I'm open to all approaches
IF( DimCalendar[YoY growth] >= "+", DimCalendar[YoY growth], SWITCH(TRUE, DimCalendar[YoY growth] < 0 && DimCalendar[YoY growth] >= -10, "-1 to -10", DimCalendar[YoY growth] < -10 && DimCalendar[YoY growth] > -50, "-11 to -50", DimCalendar[YoY growth] <= -50, "-50" ) )
Solved! Go to Solution.
@Zozozop , You have to create dynamic Segmentation
Dynamic Segmentation Bucketing Binning
https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-Segmentation-Bucketing-Binning/m-p/1...
Dynamic Segmentation, Bucketing or Binning: https://youtu.be/CuczXPj0N-k
@Zozozop , You have to create dynamic Segmentation
Dynamic Segmentation Bucketing Binning
https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-Segmentation-Bucketing-Binning/m-p/1...
Dynamic Segmentation, Bucketing or Binning: https://youtu.be/CuczXPj0N-k
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
124 | |
89 | |
84 | |
70 | |
51 |
User | Count |
---|---|
206 | |
143 | |
97 | |
79 | |
68 |