Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I am currenctly trying to write a calculated column to Filter Visuals.
I would like to use it to filter what weight range a shipment is in.
Now I have done this (sorry, it won't let me insert this as Code):
PS: the Column is formatted as number.
Can someone help me? Something is clearly wrong.
Thanks in advance
Laura
Solved! Go to Solution.
Hi @Laura0403 ,
Based on your description, I have created a simple sample:
Please try:
Filter_Gewichtstaffel =
SWITCH (
TRUE (),
frkostsoll[gewicht] >= 0
&& frkostsoll[gewicht] <= 1.99, "0-1,99",
frkostsoll[gewicht] >= 2
&& frkostsoll[gewicht] <= 4.99, "2-4,99",
frkostsoll[gewicht] >= 5
&& frkostsoll[gewicht] <= 9.99, "5-9,99",
frkostsoll[gewicht] >= 10
&& frkostsoll[gewicht] <= 14.99, "10-14,99",
frkostsoll[gewicht] >= 15
&& frkostsoll[gewicht] <= 24.99, "15-24,99",
frkostsoll[gewicht] >= 25
&& frkostsoll[gewicht] <= 29.99, "25-29,99",
frkostsoll[gewicht] >= 30
&& frkostsoll[gewicht] <= 39.99, "30-39,99",
frkostsoll[gewicht] >= 40
&& frkostsoll[gewicht] <= 59.99, "40-59,99",
frkostsoll[gewicht] >= 60
&& frkostsoll[gewicht] <= 79.99, "60-79,99",
frkostsoll[gewicht] >= 80, ">=80",
"N.v."
)
Final output:
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Laura0403 ,
Based on your description, I have created a simple sample:
Please try:
Filter_Gewichtstaffel =
SWITCH (
TRUE (),
frkostsoll[gewicht] >= 0
&& frkostsoll[gewicht] <= 1.99, "0-1,99",
frkostsoll[gewicht] >= 2
&& frkostsoll[gewicht] <= 4.99, "2-4,99",
frkostsoll[gewicht] >= 5
&& frkostsoll[gewicht] <= 9.99, "5-9,99",
frkostsoll[gewicht] >= 10
&& frkostsoll[gewicht] <= 14.99, "10-14,99",
frkostsoll[gewicht] >= 15
&& frkostsoll[gewicht] <= 24.99, "15-24,99",
frkostsoll[gewicht] >= 25
&& frkostsoll[gewicht] <= 29.99, "25-29,99",
frkostsoll[gewicht] >= 30
&& frkostsoll[gewicht] <= 39.99, "30-39,99",
frkostsoll[gewicht] >= 40
&& frkostsoll[gewicht] <= 59.99, "40-59,99",
frkostsoll[gewicht] >= 60
&& frkostsoll[gewicht] <= 79.99, "60-79,99",
frkostsoll[gewicht] >= 80, ">=80",
"N.v."
)
Final output:
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Jianbo Li,
thanks a lot. I don't know why I haven't thought about the switch.
I guess my brain had some problems that day 😄
Now it works, thanks a lot.
Laura 🙂
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
95 | |
80 | |
67 | |
62 |
User | Count |
---|---|
147 | |
109 | |
107 | |
85 | |
63 |