Forum Discussion

abgnfirdaus's avatar
abgnfirdaus
Helper I
4 years ago
Solved

multiple column in one slicer

Hello there, hope you guys can help me by show and tell. Also, tutorial request. Let say the table is: Equipment Voltage Red cable Blue cable Yellow cable TRU 1 6.6kV 0.23 0.45 0.65 ...
Need Help
Show and Tell
Tutorial Requests
v-janeyg-msft's avatar
v-janeyg-msft
Community Support
4 years ago

Hi, abgnfirdaus 

 

It looks like your real data and sample data are different, the context should be different, so the original method doesn't work.

I saw that you have marked the answer to your new question, use the unpivot column method, this solution is versatile but will change the format of the original data, you can do it if you think it is possible.

 

Best Regards,
Community Support Team _ Janey

abgnfirdaus's avatar
abgnfirdaus
Helper I
4 years ago

yeah. i have tried the unpivot things. but i noticed that i only can do unpivot things once only. After that I want to unpivot another column for another slicer, then it shows error. 

  • v-janeyg-msft's avatar
    v-janeyg-msft
    Community Support
    4 years ago

    Hi, abgnfirdaus 

     

    I believe this is not difficult, you need to know more about the basics. New problems will have new engineers to help you solve.

     

    Best Regards,
    Community Support Team _ Janey