Line graph, data points and filters visualization visualization in PBI

[amitpbi73270]

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 to include 3 filters namely l6, l2,l4 so that when we select these values then the corresponding line graph is formed with k and F values plotted along the  y and x axis respectively.

I  need to show each of the data point values in this line graph of K and F when I select the filter values say l6,l4,l2. By seeing the line graph, i should be able to know which  K and F values corresponds to which selected values of l6,l2,l4 . It should look like the expected visual screenshot below. 

If this can be achieved in excel itself instead of PBI , i am fine with that approach too.

regards
Amit

input data 

l6(mm)	l2(mm)	l4(mm)	F(nN)	k(N/m)
1	418	155	1	-11.01890
2	421	157	3	-10.92004
3	425	160	5	-10.7735
4	430	165	7	-10.5264
5	440	180	9	-9.88140
8	470	200	11	-9.08361

mm is millimeter and nN is nanonewton units

Expected visual

[Anonymous · Accepted solution]

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.

[foodd]

Hello @amitpbi73270 , and thank you for sharing a question with the Community.  This reply is informational.  Please remember to adhere to the decorum of the Community Forum when asking a question.

Please provide your work-in-progress Power BI Desktop file (with sensitive information removed) that covers your issue or question completely in a usable format (not as a screenshot). You can upload the PBIX file to a cloud storage service such as OneDrive, Google Drive, Dropbox, or to a Github repository, and then share a file’s URL.

https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

This allows members of the Forum to assess the state of the model, report layer, relationships, and any DAX applied.

If your requirement is solved, please make THIS ANSWER a SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.  Proud to be a Super User!