Forum Discussion

harvis's avatar
harvis
Frequent Visitor
8 years ago
Solved

Format on measure lost when connected to SSAS Tabular model

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?

Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    8 years ago

    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)). :smileyhappy:

     

    Regards

1 Reply

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    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)). :smileyhappy:

     

    Regards