Forum Discussion
Format loss when unpivoting columns
I am working on a report where in the source file, I have a set of columns expressed in different format types (a few are percentages, some are currency, others are fixed decimal number). Because my...
Apologies as I might not have explained this very well.
In my first power query step, I have 5 columns which get unpivoted into only 1 column. I can change formats for this resulting column but I want to be able to have different data types depending on the row value. Is that possible?
edhans
Community Champion
Community ChampionNo. Each column can only have one data type, or it can be a variant, where it is whatever, but that will always look like text to Power BI and is a mess.
Don't combine data types into a single column. It might be helpful to explain what you are doing, but putting units, dollars, percents, and text into a single column via Unpivot in Power BI is very likely not the right way to go.