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.
Hi,
Hi there
I've a task to work with a given excel spreadsheet which structure I can't change. It has distributed data as follows:
Name | type | july | august | september | october | november |
name 1 | actual | 2,345 | 6,789 | 6,789 | 7,891 | 4,456 |
name 1 | budget | 1,234 | 5,678 | 9,123 | 3,234 | 7,789 |
name 2 | actual | 4,567 | 1,234 | 2,234 | 5,678 | 4,456 |
name 2 | budget | 7,891 | 2,345 | 4,567 | 6,789 | 3,345 |
It has a Line and clustered column chart (cumulative), but I wonder how can I show the same charts with Power Bi. I've tried different methods without success.
Any help/ideas?
Thank you.
Solved! Go to Solution.
@j_acnail All you need to do is import the Excel file, select the columns to unpivot the months by (Name, Type) right click, unpivot other columns and this will pull things into rows that you can use.
@j_acnail All you need to do is import the Excel file, select the columns to unpivot the months by (Name, Type) right click, unpivot other columns and this will pull things into rows that you can use.
Thanks, that's what I needed.
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 |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |