KPI visual not able to display a measure formatted as percentage in Azure Analysis Services

[Anonymous]

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? 

[v-yuta-msft]

@Anonymous ,

Not sure if this issue could be summarized as a bug or a by-design issue. But I have found a similar idea, you could vote for this idea.

https://ideas.powerbi.com/ideas/idea/?ideaid=856d1f19-c45e-41c6-b2e8-ec14af52aead

Regards,

Jimmy Tao

[Anonymous]

Thanks @v-yuta-msft ,

It is not a general bug, as the format string works with e.g. the Card visual, Table visual, Matrix visual. It is just the KPI visual that does not display the measure format correctly.

[Anonymous]

@v-yuta-msft,

Actually I think it is this idea that is the correct one - and a fix is under way, presumably. Will wait then 🙂

https://ideas.powerbi.com/ideas/idea/?ideaid=9d9e204a-db28-4ced-89f9-ea56a1041a06

-Simen