Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
90 percent of all data I analyze is a combination of dollar-formatted data ALONG WITH percentage data. After cleaning data and properly categorizing it as either currency or percentage, how do I keep the unpivot process from breaking data formats. I started out using tableau add-in to unpivot columns, but it is frustrating to keep losing formats, or to have dollar and percentage amts mixed together.
Share a screenshot of the data so that I can see what you're talking about
normally I might would unpivot beginning at the "cash" column but the last 3 columns are percentage ratios formatting those numbers becomes a pain when they are mixed.
you can't have mixed formatting in a column so maybe unpivot twice - first on the numerical data and second on the percentage data
can you unpivot them separately from the same sheet, or do you need to copy/paste the percentage columns along with primary shared column to another excel sheet and do it there, effectively creating 2 tables?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |