Stacked area chart not showing percentages

[bahaaa_bouakl]

I have an OLAP Cube with a measure formatted as a percentage.

The measure itself is an index (Value1/Value2) then formatted as a percentage.

in Power BI Desktop (Version: 2.62.5222.761 64-bit (September 2018)),

I am connection wit a direct query connection to the Cube in Analysis Services (SQL 2014 Enterprise).

using Stacked area chart does not show the values as percentages but as decimal number although the measure in the cube has a "Percent" format string.

In a connection to SQL, one would be able to select the field, then in teh format menu selecct the "%" to format the measure as a percentage.

however this is not allowed in a direct cconnection to a multidimentional database OLAP cube.

[v-qiuyu-msft]

Hi @bahaaa_bouakl,

I'm not able to reproduce the issue on my side (2.62.5222.761 64-bit (September 2018), SSAS cube 12.0.2000.8). I created a measure on SSAS cube project like below: 

In your scenario, how do you create the measure? Please ensure Format String is "percent" and Visible is True as ours. 

Best Regards,
Qiuyun Yu