Graph formats percentage from tabular model as decimal while table gets it right

[Anonymous]

Hi, 

I'm using a tabular model on Azure Analysis Services, which has a few measures formatted as percentage. These measures display correctly in Excel, as well as in tables in Power BI. However, when I put them in a graph, the formatting suddenly changes to decimals, while I didn't change anything to the formatting (which is also not possible in Power BI itself with a live connection).

How is this possible? The formatting is definitely correctly set in the model itself, which also shows by the table and the formatting in Excel. The two visuals below are using the exact same measure:

I've also tried setting the formatting to a custom format string like #.##%, but that has the same effect. It shows in the table, but not in the graph. Please let me know if you have any ideas.

[v-shex-msft]

Hi @Anonymous,

It seems like compatibility between azure SQL as and power bi desktop, what version of power bi desktop and azure SQL analysis are you test? can you please provide more detailed information to help us clarify this scenario?

How to Get Your Question Answered Quickly 

Regards,

Xiaoxin Sheng

[Anonymous · Accepted solution]

Apparently it's a known issue, see: https://community.powerbi.com/t5/Issues/Graph-formats-percentage-from-tabular-model-as-decimal-while...

We completed the work but have not turned the feature on yet. It should be enabled mid August at the latest, next Monday at the earliest, we are still testing it. This is a known issue / feature gap for a long time, not a regression.

[amitchandak]

@Anonymous , have set is as % column in data format?  % sign should have a grey background if selected

[Anonymous]

Hi Amit,

I'm connecting live to Azure Analysis Services, so in Power BI there is no option to set this. Formatting is set directly in the tabular model, and there it is set to percentage.

[amitchandak]

@Anonymous , is it marked % column there?

If it marked % there and only showing on visual and not on the tooltip. Without additional formatting at the visual level. Log an issue -https://community.powerbi.com/t5/Issues/idb-p/Issues