Forum Discussion

rog_bjo's avatar
rog_bjo
Regular Visitor
7 years ago
Solved

Monthly values on the same row into column chart

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?

2 Replies

    • rog_bjo's avatar
      rog_bjo
      Regular Visitor

      Hi,

       

      Thank you! Unpivoting the months columns was the solution I was looking for. I have tested on the complete dataset and it is working.

       

       

      rog_bjo