Forum Discussion
SWITCH now conflicting with chart analytics functions
Hi DanielW -The issue you're encountering is likely due to an interaction between the switch function and percentile analytics, potentially exacerbated by recent Power BI updates. Simplifying the switch statement, removing and reapplying analytics, and ensuring your software is up to date are good first steps.Try removing the analytics, saving the report, and then reapplying the analytics. Sometimes, this can clear up issues related to corrupted or problematic configurations.
As a temporary workaround, if the KPI without the switch statement works fine, you might consider creating multiple visuals with different KPIs and using bookmarks or dynamic visuals to switch between them instead of using a switch statement within a single visual.
SWITCH function (DAX) - DAX | Microsoft Learn
Hope the above information helps you.
Hi DanielW -The issue you're encountering is likely due to an interaction between the switch function and percentile analytics, potentially exacerbated by recent Power BI updates. Simplifying the switch statement, removing and reapplying analytics, and ensuring your software is up to date are good first steps.Try removing the analytics, saving the report, and then reapplying the analytics. Sometimes, this can clear up issues related to corrupted or problematic configurations.
As a temporary workaround, if the KPI without the switch statement works fine, you might consider creating multiple visuals with different KPIs and using bookmarks or dynamic visuals to switch between them instead of using a switch statement within a single visual.
SWITCH function (DAX) - DAX | Microsoft Learn
Hope the above information helps you.
I tried most of these things but didn't get them working with the analytics yet. I'll keep trying. It seems to only be a problem in certain circumstances, so I'll dig into those areas where it is working ok.
