Forum Discussion
How to pull data through
Hi all,
Very new to powerbi. I can import data and pull data out when it is simplified and just in a column. However, when data is in this format:
And I would like to pull revenue for each quarter out onto a chart for example, how can I do that? It seems to just want me to pull out everything in the "Q1 2023" column.
If anyone could help i'd be very appreciative and please do explain like I'm five!
LE2023 Go into Power Query Editor. Select your first column, right-click and choose Unpivot other columns. You will now end up with 3 columns and this will be far easier to do what you are trying to do.
1 Reply
LE2023 Go into Power Query Editor. Select your first column, right-click and choose Unpivot other columns. You will now end up with 3 columns and this will be far easier to do what you are trying to do.