Line Chart X-Axis Dates

[david_MAS]

Hi Everyone,

I'm relatively new to Power BI and am struggling to find an answer to a question I have - although it's possible I'm not asking the question in the right way.

I'm working on visualising datasets that I receive from external organisations, and have got about 80% of what I need sorted, except for the following.

The headings in my files (in Excel) come in roughly the format shown at the bottom of the post. where we have 2 descriptive columns (Participant Name & Channel) which get populated with text information, and the monthly columns afterwards get populated with volumes (just numbers ranging between 1-3 digits - no other formatting etc.)

What i need to be able to do, is have the month columns (Apr-18 onwards) as the horizontal axis on a line and stacked column chart so that I can regularly update the volumes each month and have a running set of colums / lines to compare volumes month by month.

Obviously in Excel I'd just manually choose the month parts of the header row as my axis and then link the volumes to the relevant columns in the table, but this is too manual so any assistance would be greatly appreciated.

Apologies if there is already a solution posted to this query or if i'm missing something obvious.

Thanks

Participant Name

Channel

Apr-18

May-18

Jun-18

Jul-18

Aug-18

Sep-18

Oct-18

Nov-18

Dec-18

Jan-19

Feb-19

Mar-19

[quentin_vigne · Accepted solution]

Hi @david_MAS

For what you want you will have to pivot your table to have one line for one value. -> http://radacad.com/pivot-and-unpivot-with-power-bi

I've made an example with Eric.

With that you will be able to make what you want

- Quentin

[david_MAS]

Hi Quentin,

Ah I see, that makes sense. So in order to assign a date axis it has to be in the dataset vertically and cannot be selected manually in same manner as excel.

One more Q - If I have a dataset that only has one months data (in this case Apr-2018,) whereas other datasets being used for comparison contain a full year - such as forecast for 18/19 and volumes for the previous year - is that likely to result in a conflict?

Many thanks for your assistance. Greatly appreciated.

D

[quentin_vigne]

@david_MAS

It shouldn't create conflict. If I understand well, it this happen, PowerBI will sum or make regroupement, depending on what you have. But you will not have any conflict

You're welcome,

Have a good day

- Quentin