cancel
Showing results for 
Search instead for 
Did you mean: 

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

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:

KPI format.PNG

 

 

This is how the KPI visual looks like in Power BI:

KPI visual.PNG

 

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? 

Status: New
Comments
Community Support

@SimJohann ,

 

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

Regular Visitor

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.

Regular Visitor

@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