Forum Discussion

DanielW's avatar
DanielW
New Member
1 year ago
Solved

SWITCH now conflicting with chart analytics functions

Hi   I have an established report with a line viz that uses a switched KPI with percentile analytics across a time range. Since last week, the analytics have started breaking the viz with this erro...
Need Help
  • rajendraongole1's avatar
    rajendraongole1
    1 year ago

    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.

     

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi DanielW ,

 

Thanks rajendraongole1 for the quick reply. Please allow me to suggest other ideas:
You mentioned that the SWITCH function gives you some hindrance then could you use the IF function instead? Sometimes nested IF and SWITCH can serve the same purpose.

 

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.