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


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.

     

     

    • Hariharan_R's avatar
      Hariharan_R
      Icon for Solution Sage rankSolution Sage
      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