Forum Discussion

M-M-P's avatar
M-M-P
Icon for Helper III rankHelper III
6 years ago

How to make this visual?

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.

5 Replies

  • Mariusz's avatar
    Mariusz
    Icon for Community Champion rankCommunity Champion

    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's avatar
      M-M-P
      Icon for Helper III rankHelper III

      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's avatar
        Mariusz
        Icon for Community Champion rankCommunity Champion

        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


         

    • M-M-P's avatar
      M-M-P
      Icon for Helper III rankHelper III

      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.