Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |