Clustered column chart with several values and months used as legend

[muelleto]

Hi,

I hope anybody can help me. I have a table with several demands. In the table I have the columns 'closed timestamp', 'demand phase', and 7 columns for the duration in days for every demand phase.

In the end I'd like to have this chart but with all seven demand phases (for better overview I used here just three) and the month should be displayed in different colors and the demand phase should be represented by the x-axis. In short words: I'd like to switch the x-axis and the legend. Unfortunatly PowerBi only let's me set the 'closed tiemstemp' as legend if I use just one value and not all seven.

Any ideas how to solve this problem?

Thank you so much!

Br, Tom

[muelleto]

The values are the averages of every demand phase. So average of approval phase, avergae of collection phase, average of qualify phase, average of...

So yeah it's possible to get the demand phases to the axis level but then I'm not able anymore to set the color saturation for the months. I somehow need to bring all the average values of all the demand phase duration colums into one.

[v-huizhn-msft · Accepted solution]

Hi @muelleto，

Please select the demand phases to the axis level, month as legend level, the "average of demand phases" as value level. As the following screenshot shown, please click Data colors(highlighted in red line) under formut button.

If you have any issue, please feel free to ask.

Best Regards,
Angelia

[muelleto]

@v-huizhn-msft Thanks for your input but this unfortunatly doesnt solve my problem.

What I'd like to get in the end should look like this. The diffrent colors represent the diffrent months. Any ideas how to solve this maybe with a little bit powerquery magic? 😄

Thanks again for any ideas 🙂

Br, Tom

[v-huizhn-msft]

Hi @muelleto,

What's the mean of the value of histogram? Can't you put the date as legend level, the Demand Phase as Axis level?

Best Regards,
Angelia

[muelleto]

Sorry I can't share the data but a row looks like this

DemandId	Demand Phase	closed timestamp	Collection Phase Duration in days	Approval Phase Duration in days	Qualify Phase Duration in days
123456	Approval	22.08.2016	12.3	5.7	47.3
654321	Qualify	24.07.2016	10.5	7.5	10.5

[v-huizhn-msft]

Hi @muelleto,

In a  clustered column chart, there is only one Axis level. When you select several fields as Axis level, it will drill down according the order you put. It will jump to a new chart when you click the highlighted button like the picture below.

While, we can't put multiple fields as Legend level, we only can put one. Because it can’t determine which group of series need to be “clustered”.

If this doesn't resolve your issue, please post the detail expected result based on your given data.

Best Regards,
Angelia

[PavelR]

Would be helpful if you could provide sample data or pbi file.

Regards.

Pavel