How to make this visual?

[M-M-P]

Hi
I'm trying to make this visual in Power Bi. The image is made in Photoshop.
The lines are different temperature measurements and the bars show which hours are "Risk hours".

I have a Data table with temperature, risk hour, name, timestamp columns.

Shouldn't you be able to make this? I can't find a combination that works.

Thanks in advance.

[amitchandak]

@M-M-P , You create risk out Static value or use what if for that. And then use Line column or line clustered chart.

https://docs.microsoft.com/en-us/power-bi/desktop-what-if

[M-M-P]

Hi @amitchandak 
Thanks for the answer.

I'm not sure I understand what you mean by "You create risk out Static value".

The risk hours are a boolean 1 and 0.

[Mariusz]

Hi @M-M-P 

It's the line and clustered column chart as per below.

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

[M-M-P]

Hi @Mariusz 

Thanks for the answer.

Great, how do you get it to split up the line and not the bars?

When I use it it looks like this.

In the upper visual, risk hours are placed in Column values and in the one below the risk hours are added in Line values.

Am I doing something completely wrong?

[Mariusz]

Hi @M-M-P 

As you can see in the picture that you posted, there is only Measure on in the columns and the rest would be lines.

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn