line chart, type of cable against date tested

[abgnfirdaus]

Hello there, hope you guys can help me by show and tell. Also, tutorial request. Let say the table is:

Date Tested	Equipment	Red cable	Blue cable	Yellow cable
2018	TRU 1	0.23	0.45	0.65
2019	TRU 1	0.25	0.48	0.69
2020	TRU 1	0.28	0.5	0.71
2018	TRU 2	0.32	0.5	0.7
2019	TRU 2	0.35	0.53	0.74
2020	TRU 2	0.38	0.58	0.78

Then, I want to put 3 columns in one slicer, show list of :
Slicer :

• Red cable
• Yellow cable
• Blue cable
  The result should be in line chart where y-axis is cable and x-axis is date tested. The equipments also in slicer so that only data of one equipment shown in the line chart.
  Also, when I click Red cable, the data in Red cable will display against Date tested on line chart. Then, If I click yellow cable, then the line chart will display yellow cable data only against Date tested. Same as blue cable also. So, basically i need to choose which equipment first, then choose which cable i want to display on the line chart.
  
  Hope you can help me. thank you in advance.

[ALLUREAN · Accepted solution]

Hi, @abgnfirdaus 

Please find this solution:

https://www.dropbox.com/s/ic363uhtlr6pamo/line%20chart%2C%20type%20of%20cable%20%28allure-analytics....

You will need to unpivot cable columns in power query (select three columns Red,Blue, Yellow and Unpivot) and use them as category (default name Attribute).

Did I answer your question? Please Like and Mark my post as a solution if it solves your issue. Thanks.

Appreciate your Kudos !!!

https://allure-analytics.com/

https://www.youtube.com/channel/UCndD_QZVNB_JWYLEmP6KrpA

https://www.linkedin.com/company/77757292/

[ALLUREAN · Accepted solution]

Hi, @abgnfirdaus 

Please find this solution:

https://www.dropbox.com/s/ic363uhtlr6pamo/line%20chart%2C%20type%20of%20cable%20%28allure-analytics....

You will need to unpivot cable columns in power query (select three columns Red,Blue, Yellow and Unpivot) and use them as category (default name Attribute).

Did I answer your question? Please Like and Mark my post as a solution if it solves your issue. Thanks.

Appreciate your Kudos !!!

https://allure-analytics.com/

https://www.youtube.com/channel/UCndD_QZVNB_JWYLEmP6KrpA

https://www.linkedin.com/company/77757292/

[abgnfirdaus]

can you show me on how to unpivot and how to categorize it as attribute. thank you!

[ALLUREAN · Accepted solution]

[abgnfirdaus]

Thank you. is it possible to unpivot many times?