Power BI - Dynamic Format Strings - Pie Charts

Hi southgrad10 

Just checking is this a correct description of what you're doing?

• Creating a Power BI report with live connection to Analysis Services Tabular
• Trying to create a "report measure" with a dynamic format string

If that's correct, unfortunately report measures cannot have dynamic format strings.

Also, if you switched to DirectQuery for Analysis Services (which is possible for Analysis Services Tabular version 2022+), local model measures with dynamic format strings are not currently possible.

See here for more description of the limitations.

Alternatives that you could consider:

• Create a calculation group in the Analysis Services model to handle dynamic format strings (I think this requires Analysis Services Tabular 2019+).
• If you are using Analysis Services Tabular 2022+, switch to DirectQuery for Power BI Datasets and Analysis Services and create a calculation group in the local model to handle dynamic format strings.

Regards

No worries 🙂

For calculation groups, you need compatibility level 1500 (which should be Analysis Services 2019+), so if you've already updated your Analysis Services model to that you should be good to go with calculation groups.

I'm assuming you were going to create a calculation group in the AS model containing a calculation item with expression

SELECTDMEASURE ( )

and format string expression along the lines of your original post, then apply that as a filter on the visual in the Power BI report.

Please post back if needed 🙂