Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 :
Solved! Go to Solution.
Hi, @abgnfirdaus
Please find this solution:
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://www.youtube.com/channel/UCndD_QZVNB_JWYLEmP6KrpA
https://www.linkedin.com/company/77757292/
Proud to be a Super User!
Proud to be a Super User!
Hi, @abgnfirdaus
Please find this solution:
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://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!
Proud to be a Super User!
Thank you. is it possible to unpivot many times?
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |