Excuse me for my limited knowledge.
I have a large dataset built as follows (simplified):
and I have been able to transfer this into a new presentation that looks like this by adding custom columns for each month;
by using the folowing formula:
= Table.AddColumn(#"Added Custom", "Jan", each if [Start] < #date(2019,1,5) and [End] > #date(2019,1,25) then [Resources] else null)
This works as I hoped it will, and even looks pretty when I add "conditional formatting"to the result.
But I was also hoping to present this in a column chart like this:
I am able to do this in Power BI, but I dont have any customisation possibilities for the chart in the built-in visuals.
I have tried linking it to a date-range table (to use monthly as the axis), but as I understand this table can only be linked to start or end date, since the other columns only contains numbers.
Any suggestions what I sholud try next?