Forum Discussion

MoeCodez's avatar
MoeCodez
Frequent Visitor
8 years ago

Cannot format data from SSAS data model in a Matrix

I've created a Matrix that is populated with data from a tabular model in SSAS.   I want to change the number of decimal places on one of fields but am unable to because all the Formatting options are greyed out.  Oddly, if I create a measure in PBI based on data from the model I can then change the format of that measure.  Why are the formatting options greyed out for the original SSAS data?

 

 

 

I'm using the March release of PBI Desktop SSRS version

 

Need Help

1 Reply

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    8 years ago

    Hi MoeCodez,

     

    Was the model live connection? If so, I'm afraid this is expected. You need to change the data type in the SSAS server. 

    The workaround could be using a measure with the function "Format".

    Cannot_format_data_from_SSAS_data_model_in_a_Matrix

     

    Best Regards,

    Dale