Table Values with Multiple Data Types

[indyb]

Hi all, 

I am working on a table where there is a value column with multiple data types in the Excel. 

I would like to pull through these values as the data type that they are. Some are percentages (pulling through as decimals), some are currency (pulling through as Text as below with £) and some are just text. 

Example of Current  : 

Example of desired output : 

Is this possible? 

Many thanks in advance for any help! 

[v-xuding-msft · Accepted solution]

Hi @indyb ,

For columns, we only can change it to one formatting type. For example, the Column1 only can be formatted by %percentage. It can't show 22.30%, $0.256 and £0.456. It is impossible to show multiple formatting for one column.

Maybe you could transpose your table to make data in multiple different columns and then format them one by one.

And you could vote the idea up and submit comments there to get it fixed quickly.  If it is not what you want, you could submit a new idea here.

Formatting of row values 

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Greg_Deckler]

I don't think everything came through. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490