Forum Discussion

alexw94's avatar
alexw94
Helper I
3 years ago
Solved

Need help creating a PowerBI graph please.

Hi,   I am looking to create the follow graph (right of screenshot) from the data in table (left of the screenshot) in Power BI.    So far I have the below table in my power query editor exactly ...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi alexw94 ,

     

    Please try to create a calculated column.

    Category 2 = IF('Table'[Category]<>"Other",'Table'[Trip No],"Other")

    Result.

    Best Regards,
    Gao
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

AdaKAda's avatar
AdaKAda
Helper I
3 years ago

It looks exaclty like a stacked column chart with km on Y-axis and TripNo in Legend, Category on Y axis. 

Unfortunately the stacked column chart doesn't allow you to use the data label (i.e trip name) on the bars, but only the values. 

alexw94's avatar
alexw94
Helper I
3 years ago

Thanks for your reply, I am not wanting to put the names of the columns on the bars. I know they can apear appear as you hover over them with the mouse.