Percentage Symbol Not Showing on Charts

[Anonymous]

I tried searching for this under "Issues" but could not find anything.  Sorry if I'm duplicating.

Connecting to a SQL Server Analysis Services cube live, the percentage symbol does not appear on charts, but does on tables, cards and matrices:

c.f. https://community.powerbi.com/t5/Desktop/Percent-display-issue-in-charts-in-olap-live-connection/m-p...

Thanks,
Ian.

[v-qiuyu-msft]

Hi @Anonymous ,

I have consulted this issue internally, will update here once I get information. 

Best Regards,
Qiuyun Yu 

[v-qiuyu-msft]

Hi @Anonymous,

I got information that this is currently by design. Dynamic format string (e.g. %, $ etc) not appearing when connecting live to SSAS multi-dimensional cube on charts. 

Best Regards,
Qiuyun Yu 

[Anonymous]

Hi @v-qiuyu-msft ,

Thank you for the response.

With no offence intended, I see the decision taken as very odd.  Extremely odd.  Why a measure would be treated differently in a table compared to a chart is a design decision I am having trouble seeing the positives with.  Could you explain a bit more as to the decision?

Also, I do not seem to be able to find anyway to show a percentage sign on a chart with a connection to a live SSAS cube.  Is this due to my not knowing a way, or is there no way currently in Power BI to do this?  I am banging on about this because when business users get a dashboard and see a chart that represents a percentage of total figure, they expect to see a percentage sign on the axis or on the data label.  This is the first thing users and testers have mentioned to me -- it is not some "nice to have" but a necessary display in their view.  Add to this the fact that while on one tab they see charts showing a percentage measure (with no % sign visible) and on another tab we have the same measure in a table for a different purpose, and the table shows the % sign, they get a bit confused.

Thanks for your time,
Ian.