Forum Discussion

WayneM's avatar
WayneM
Regular Visitor
6 years ago
Solved

Column data formatting options greyed out

Hi, I am trying to format a number value as currency by selecting the table field on the right hand side and using the formatting options in the 'column tools' tab but all formatting options are gre...
Need Help
  • WayneM's avatar
    WayneM
    6 years ago

    Thanks for your responses, I have done the formatting on measures in Azure Analysis Services - its not ideal as PowerBi then treats the currency and percentage formatted numbers as text but works for my current requirements

v-lili6-msft's avatar
v-lili6-msft
Community Support
6 years ago

hi  WayneM 

For your datasource is Azure Analysis Services, so you must use live connection model.

In this model, you could do any modeling in the power bi, since ssas is a complete data model, all the modeling must be done in ssas, you could only create a report level measure in power bi and do formatting for this measure.

 

https://radacad.com/live-connection-when-power-bi-comes-hybrid

 

 

Regards,

Lin