Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
abgnfirdaus
Helper I
Helper I

line chart, type of cable against date tested

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

Date TestedEquipmentRed cableBlue cableYellow cable
2018TRU 10.230.450.65
2019TRU 10.250.480.69
2020TRU 10.280.50.71
2018TRU 20.320.50.7
2019TRU 20.350.530.74
2020TRU 20.380.580.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.
2 ACCEPTED SOLUTIONS
ALLUREAN
Solution Sage
Solution Sage

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/




Did I answer your question? Mark my post as a solution!


https://allure-analytics.com/
https://www.youtube.com/channel/UCndD_QZVNB_JWYLEmP6KrpA
https://www.linkedin.com/company/77757292/

Proud to be a Super User!




View solution in original post

how to unpivot.png




Did I answer your question? Mark my post as a solution!


https://allure-analytics.com/
https://www.youtube.com/channel/UCndD_QZVNB_JWYLEmP6KrpA
https://www.linkedin.com/company/77757292/

Proud to be a Super User!




View solution in original post

4 REPLIES 4
ALLUREAN
Solution Sage
Solution Sage

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/




Did I answer your question? Mark my post as a solution!


https://allure-analytics.com/
https://www.youtube.com/channel/UCndD_QZVNB_JWYLEmP6KrpA
https://www.linkedin.com/company/77757292/

Proud to be a Super User!




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

how to unpivot.png




Did I answer your question? Mark my post as a solution!


https://allure-analytics.com/
https://www.youtube.com/channel/UCndD_QZVNB_JWYLEmP6KrpA
https://www.linkedin.com/company/77757292/

Proud to be a Super User!




Thank you. is it possible to unpivot many times?

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.