Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
While writing a switch statement (Calculated Column) with multiple conditions, the condition is working fine in the Desktop App but upon publishing in the web service only the else condition is coming in the web service i.e pending condition. This happens when a refresh is happening from the database. Not sure, why it is happening but need the fix soon.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
When I changed to Import mode and refresh the dataset, it still works fine in my side which is the same as the previous.
'Can we create it as a measure?'
If you want to use it in the slicer, measure is not supported to achieve it in Power BI.
Whether you can consider providing a sample test file without any sentive information that could reproduce this issue.
Best Regards,
Community Support Team _ Yingjie Li