Hi , I want to show decimal values with some % values in same Power BI table, how to achieve this ?

[Anonymous]

Hi , I want to show decimal values with some % values in same Power BI table, how to achieve this ?

[v-yalanwu-msft · Accepted solution]

Hi, @Anonymous ;

You could create a dax measure as follows:

May 2021  Actual2 =
IF (
    CONTAINSSTRING ( MAX ( [SAR] ), "%" ),
    FORMAT ( MAX ( [May 2021  Actual] ), "percent" ),
    MAX ( [May 2021  Actual] )
)

May 2021 Budget2 =
IF (
    CONTAINSSTRING ( MAX ( [SAR] ), "%" ),
    FORMAT ( MAX ( [May 2021 Budget] ), "percent" ),
    MAX ( [May 2021 Budget] )
)

The final output is shown below:

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Thanks @selimovd 

The issue with me is all values I am fetching from a table and in table some values are in decimal where some are in %. 

now I want to show these 0 and 1 to %.

hope I am clear now ??

[selimovd]

Hey @Anonymous ,

for each column or measure you can change the type. Select the column or measure "Contribution Margin (%)", to to the tab "Measure tools" / "Column tools" and chose "Percentage" as Format:

Then for the Sales you chose decimal number or currency and so on.

In the matrix the correct formatting will be shown then.

Does that help?

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[Hank_Lotion_77]

I made a profile just to persionally tell you that this was incredibly helpful! In the PBI world where everyone wants to boil the ocean a sweet and simple repsonse to get the job done is a light in the otherwise darkness of data. Thanks friend! 

[Anonymous]

I dont have any calculated column and measures. I have only straight forward columns. Like you can see in screenshot. I am also sending you screenshot of table which I want to prepare in Power BI.

Can you please provide a solution now.

[ryan_mayu]

@Anonymous 

what about set the column data format to %?

[selimovd]

Hey @Anonymous ,

you can add the measure with decimal values and the measure with percentage to the same Power BI table.

Just drop them in the same matrix.

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic