Forum Discussion

stefgiorgi's avatar
stefgiorgi
Frequent Visitor
4 years ago
Solved

Having multiple lines on line graph using Maximo kpihistory table as the data source.

I am new to Power BI (just started yesteday) andd need some help on how to add multiple kpi histories to the same graph as the way I am currently doing it will only allow one.

 

I did look a one video but they seemd to have more options - I am using the free verison.

 

I am using the kpimainid, Date and Total columns from kpihistory table and need to be able to reference multiple kpimainids for my graphs.

 

kpimainidNameTotalDate 
3333PBL - KPI 0001060909-Jul-22
3333PBL - KPI 0001060910-Jul-22
3333PBL - KPI 0001060911-Jul-22
3333PBL - KPI 0001059312-Jul-22
3333PBL - KPI 0001059213-Jul-22
3333PBL - KPI 0001058414-Jul-22
3334PBL - KPI 0003456925-Jun-22
3334PBL - KPI 0003456925-Jun-22
3334PBL - KPI 0003457026-Jun-22
3334PBL - KPI 0003457027-Jun-22
3334PBL - KPI 0003458128-Jun-22
3334PBL - KPI 0003457829-Jun-22
3334PBL - KPI 0003457430-Jun-22

 

I have also include how I have set up my line graph.

 

 

Need Help

6 Replies

  • Hariharan_R's avatar
    Hariharan_R
    Icon for Solution Sage rankSolution Sage
    4 years ago

    Hi stefgiorgi 

    If you expecting mulitiple lines for example for each "kpimainid" you need a line then drag and drop the kpimainid column into legend section of the visual.

    Thanks

    Hari

    • stefgiorgi's avatar
      stefgiorgi
      Frequent Visitor
      4 years ago

      Thankyou Hariharan_R that has worked.

      I have one other question as the kpimainid is just a number i.e. it doesnt have the description of what it represents, can this be renamed?

       

       

      • Hariharan_R's avatar
        Hariharan_R
        Icon for Solution Sage rankSolution Sage
        4 years ago

        Hi stefgiorgi 

        Yes. You can create one more column with whatever name you want to give for each ID and use that column in the legend. You also can define the ID and name in excel and get the excel inside the POwer BI desktop and join with ID column and use that name column.

        Thanks

        Hari

        Did I answer your question? Then please mark my post as the solution.
        If I helped you, click on the Thumbs Up to give Kudos.

        My Blog :: YouTube Channel :: My Linkedin


  • stefgiorgi's avatar
    stefgiorgi
    Frequent Visitor
    4 years ago

    Hariharan_R 

    I have imported an excel sheet with the ID , Name and Description.

     

    How do I join the kpimainid from kpihistory to ID in the excell sheet?

    I should also point out that I am using a direct connect to my sql database.

    PS. Thank you for all your help so far.