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

Hey Alex, did you run into any problems with my suggestion of a stacked column chart with km on Y-axis and TripNo in Legend, Category on Y axis? 

 

Anonymous's avatar
Anonymous
Not applicable
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