Format on measure lost when connected to SSAS Tabular model

[harvis]

Steps:

1. In Power BI Desktop (PBD) connect to a SSAS Tabular model (running on SQL Server 2012 SP1) using live connection

2. In this model we have a measure that is formatted as percentage, this is working in Excel

3. In PBD this measure is showing as decimalnumber, so I tried this DAX formula:

Measure % = FORMAT('Fact CUBE'[Mesaure];"Percent")

4. When using Table visual in PDB this works:

5. Then i try displaying this in Line Chart visual and no values i showing, I have tried doing all kinds of formatting but the value won't show.

Any ideas?

[v-ljerr-msft · Accepted solution]

Hi @harvis,

Based on my test, if the format of a measure in SSAS Tabular model is properly set with SSDT like below, the format will remain when connected with Power BI Desktop(Live). 

In addition, make sure you're using the latest version of Power BI Desktop(2.50.4859.502 64-bit (September 2017)). 

Regards