topic Re: data type in Power Query

data type

MSAYED26 — Sun, 21 Apr 2024 14:01:06 GMT

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

Re: data type

Greg_Deckler — Sun, 21 Apr 2024 14:22:12 GMT

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.

Re: data type

Anonymous — Tue, 23 Apr 2024 03:04:37 GMT

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.

Re: data type

MSAYED26 — Tue, 23 Apr 2024 19:18:45 GMT

This table before unpivot

after unpivot

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

Re: data type

MSAYED26 — Tue, 23 Apr 2024 19:23:37 GMT

In Table is ok

but in column chart not working

Re: data type

Anonymous — Wed, 24 Apr 2024 01:18:17 GMT

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.