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

DataZoe's avatar
DataZoe
Microsoft Employee
6 years ago

Hi WayneM ,

 

The format would need to be set in Azure Analysis Services. You can get around this by creating a measure that points to that measure you are trying to format. You should then be able to format that.

 

New Sales = [Sales]

 

as an example.