Forum Discussion

amitpbi73270's avatar
amitpbi73270
New Member
2 years ago
Solved

Line graph, data points and filters visualization visualization in PBI

Hi experts, I have a set of test data in excel format as shown in input data below .I want to display it in a visualization say line chart as shown in expected visual in the below screenshot. I need...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi amitpbi73270 ,

     

    Thanks for the reply from foodd , please allow me to provide another insight: 

     

    1. In the Power Query Editor, hold down the CTRL key to select the three columns l6, l2, and l4, and then select Unpivot.

     

    2. After getting this result, select Close and Apply.

     

    3. Add the attribute field to the slicer, add the F and K fields to the X and Y axes of the line chart, and add the value field to the tooltips.

    If your Current Period does not refer to this, please clarify in a follow-up reply.

     

    Best Regards,

    Clara Gong

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.