Forum Discussion
Line Chart X-Axis Dates
Hi Anonymous
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
Hi Anonymous
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
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
Anonymous
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