Forum Discussion

themistoklis's avatar
themistoklis
Icon for Community Champion rankCommunity Champion
8 years ago
Solved

Multiple Line Graph with one Dimension on each Axis and 4 Measures

Hello All,   I have created a line graph which has the year month on X Axis and 4 measures displayed on Y Axis. See following Image: I would like to take the analysis one step further and ad...
Need Help
  • v-yuta-msft's avatar
    v-yuta-msft
    8 years ago

    Hi themistoklis,

     

    To achieve your requirement, click query editor-> transform->click on [service1], [service2], [service3] and [service4]->  unpivot columns.

     

     

    Then click add columns-> custom column to merge column [person] and [attribute] like below;

      

     

    Then applied and close, create a line chart and a slicer on person column.

     

     

    Regards,

    Jimmy Tao

     

v-yuta-msft's avatar
v-yuta-msft
Icon for Community Support rankCommunity Support
8 years ago

Hi themistoklis,

 

To achieve your requirement, click query editor-> transform->click on [service1], [service2], [service3] and [service4]->  unpivot columns.

 

 

Then click add columns-> custom column to merge column [person] and [attribute] like below;

  

 

Then applied and close, create a line chart and a slicer on person column.

 

 

Regards,

Jimmy Tao

 

themistoklis's avatar
themistoklis
Icon for Community Champion rankCommunity Champion
8 years ago

Hello v-yuta-msft

 

This indeed works great on the data and when the 4 services belong to an existing table

 

In my case these 4 services are calculated measures (4 fields) in PowerBi and they dont actually belong to an existing table.

Is there a way if these are calculated measures to display them on the graph, or they all need to be on an existing table?