Forum Discussion
Changing Dimensions from axis to line.
Hello, I am building a report based on a few store performances over a years time. Currently I have a line chart below. Where I am running into trouble is switching store and the months. ...
HotChilli
Community Champion
Community ChampionIf you look at your data, the columns are the month, what you really want is to get the month into the data (and not being a header).
You need to unpivot the month columns. Edit the query. Select all the month columns and choose 'Unpivot columns' from the Transform section.
The table will then look a bit more like a 'fact' table with grain of 'StoreName', 'Month','Value' (or similar depending on what you name your columns)
Save the query and create your line chart
Oh, I should have mentioned that this particular table is created using DAX so using query editor to unpivot it isn't possible, unless there is some method of referencing a DAX table in Query Editor that I do not know about.