Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
TRU 2 | 6.6kV | 0.32 | 0.5 | 0.7 |
TRU 3 | 6.6kV | 0.4 | 0.56 | 0.75 |
Then, I want to put 3 columns in one slicer, show list of :
Slicer :
Solved! Go to Solution.
Hi,
In the Query Editor, right click on the first 2 columns and select "Unpivot other columns". Rename the Attribute column to Cable type. Now create your slicer.
Hope this helps.
Hi, @abgnfirdaus
According to your description, I think you can create a single cable table with all colors and create a measure in line chart to filter.
Like this:
Measure =
SWITCH (
TRUE (),
SELECTEDVALUE ( Table2[Cable] ) = "Blue", SUM ( 'Table'[Blue cable] ),
SELECTEDVALUE ( Table2[Cable] ) = "Red", SUM ( 'Table'[Red cable] ),
SELECTEDVALUE ( Table2[Cable] ) = "Yellow", SUM ( 'Table'[Yellow cable] )
)
Did I answer your question? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.
Best Regards,
Community Support Team _ Janey
hai. thank you for your solution. can you make a video on how you do it. From step on how you make the new table and how you add the measure for the filter. Im new to the Power BI. Im very sorry. Hope you can guide me. Thank you very much.
Thank you so much for your help. Can you help me with this one also.
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].
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.
@abgnfirdaus Put 'equipment' field in legend, If you still have problems, show me the screenshot (Mosaic Privacy).
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
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.
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
@abgnfirdaus , Create a measure slicer , examples
measure slicer
https://www.youtube.com/watch?v=b9352Vxuj-M
https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/50...
https://radacad.com/change-the-column-or-measure-value-in-a-power-bi-visual-by-selection-of-the-slic...