We have created a report based on a tabular model created in Azure Analysis Services (live connection). All measures are created in AAS. For some reason, the standard KPI visual is not able to display a measure formatted as percent in AAS as a percent in the Power BI report.
This is the measure definition:
EBITDA i % = DIVIDE([EBITDA (driftsresultat)],[Brutto varesalg])
This is the formatting in AAS shown in Tabular Editor:
This is how the KPI visual looks like in Power BI:
The measure displays correctly in the standard card visual and in Excel when connected to AAS. It also displays correctly in the KPI visual if we create the measure directly in Power BI and format it as a percentage there.
Is this a known bug with the KPI visual or is there another format string that should be used in AAS?