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 vi...
Need Help
  • Hariharan_R's avatar
    Hariharan_R
    4 years ago

    Hi stefgiorgi 

     

    Glad it works. Can you please giv kudos and mark it as a solution?

     

    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


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 

        IAfter what you said I realise I already had the kpimain table as a direct connection so have made the join with that. All now working as I need.

        Once again thatks for all your help.