data type

[MSAYED26]

I have a Decimal number coulmns and Percentage number coulmns ,I want to unpivot coulmns in one coulmns with the same value of each column 

[v-xinruzhu-msft · Accepted solution]

Hi,

@Greg_Deckler , thanks for your concern about the problem, and i want to offer some more information for user to refer to.

hello @MSAYED26 , based on your description, do you want to keep the original data type when unpivoting the column? if you want to achieve, it it better that implement this in power bi desktop by using measure or calculated column, becasuse when you set in power query , it will always return decimal number in power bi desktop.

so you can try the solution.

Original data

After unpivoting

Apply it , then you can consider to create a measure.

e.g 

MEASURE =
IF (
    MAX ( 'Table'[Attribute] ) = "%",
    FORMAT ( SUM ( 'Table'[Value] ), "percent" ),
    SUM ( 'Table'[Value] )
)

Output

Best Regards!

Yolo Zhu

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

[v-xinruzhu-msft · Accepted solution]

Hi,

@Greg_Deckler , thanks for your concern about the problem, and i want to offer some more information for user to refer to.

hello @MSAYED26 , based on your description, do you want to keep the original data type when unpivoting the column? if you want to achieve, it it better that implement this in power bi desktop by using measure or calculated column, becasuse when you set in power query , it will always return decimal number in power bi desktop.

so you can try the solution.

Original data

After unpivoting

Apply it , then you can consider to create a measure.

e.g 

MEASURE =
IF (
    MAX ( 'Table'[Attribute] ) = "%",
    FORMAT ( SUM ( 'Table'[Value] ), "percent" ),
    SUM ( 'Table'[Value] )
)

Output

Best Regards!

Yolo Zhu

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

[MSAYED26]

In Table is ok

but in column chart not working

[v-xinruzhu-msft · Accepted solution]

Hi @MSAYED26,

Thanks for your quick reply, based on your description, you can refer to the following.

I change the measure to the following.

Measure = CALCULATE(SUM('Table'[Value]))

Then create a new measure

Measure 2 = IF(SELECTEDVALUE('Table'[Attribute])="%",FORMAT([Measure],"percent"),[Measure])

Then in column chart, put the measure to the y-axis, put the measure2 to data label.

It can work.

Best Regards!

Yolo Zhu

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

[Greg_Deckler]

@MSAYED26 Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, 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

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

[MSAYED26]

This table before unpivot 

after unpivot

I want to show data like this but show Decimal number  and Percentage number in the chart