Forum Discussion

abgnfirdaus's avatar
abgnfirdaus
Icon for Helper I rankHelper 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
Icon for Community Support rankCommunity Support
4 years ago

Hi, abgnfirdaus 

 

You only need to change the column chart to a line chart, and change the field of the x-axis to [Date Tested].

abgnfirdaus's avatar
abgnfirdaus
Icon for Helper I rankHelper I
4 years ago

I have tried. nothing happened. the line chart plot nothing. I have put the Date tested in x- axis and the cable in y-axis. I put the Equipment in Slicer. and create new table for red, yellow, blue cable. then when i choose i equipment, then choose red cable, nothing plot on the graph.

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

    abgnfirdaus  Put 'equipment' field in legend, If you still have problems, show me the screenshot (Mosaic Privacy).

    • abgnfirdaus's avatar
      abgnfirdaus
      Icon for Helper I rankHelper I
      4 years ago

       

      • v-janeyg-msft's avatar
        v-janeyg-msft
        Icon for Community Support rankCommunity 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