Forum Discussion
How can insert slab in Matrix Slab
Hi Experts,
Below is the calculated column Measure, can i insert this type of slab in matirx row. i want to show slab wise sales and tagts.
AchievementSlab =
SWITCH(
TRUE(),
'Signed Target or MOU'[YTD Ach % REF] >= 0.01 && 'Signed Target or MOU'[YTD Ach % REF] < 0.10, "1%~9%",
'Signed Target or MOU'[YTD Ach % REF] >= 0.10 && 'Signed Target or MOU'[YTD Ach % REF] < 0.20, "10%~19%",
'Signed Target or MOU'[YTD Ach % REF] >= 0.20 && 'Signed Target or MOU'[YTD Ach % REF] < 0.26, "20%~25%",
'Signed Target or MOU'[YTD Ach % REF] >= 0.26 && 'Signed Target or MOU'[YTD Ach % REF] < 0.41, "26%~40%",
'Signed Target or MOU'[YTD Ach % REF] >= 0.41 && 'Signed Target or MOU'[YTD Ach % REF] < 0.51, "41%~50%",
'Signed Target or MOU'[YTD Ach % REF] >= 0.51 && 'Signed Target or MOU'[YTD Ach % REF] < 0.76, "51%~75%",
'Signed Target or MOU'[YTD Ach % REF] >= 0.76 && 'Signed Target or MOU'[YTD Ach % REF] < 0.86, "76%~85%",
'Signed Target or MOU'[YTD Ach % REF] >= 0.86 && 'Signed Target or MOU'[YTD Ach % REF] < 1, "86%~99%",
'Signed Target or MOU'[YTD Ach % REF] >= 1, "100% Above",
"Unknown"
)
1 Reply
what's a slab?
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information or anything not related to the issue or question.
If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
