Forum Discussion
Helper Imultiple 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 |
| 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 :
- Red cable
- Yellow cable
- Blue cable
Then, when I click Red cable, the data in Red cable will display on line chart. Then, If I click yellow cable, then the line chart will display yellow cable data only. Same as blue cable also.
Hope you can help me. thank you in advance.
13 Replies
- amitchandak
Super User
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/500115
https://radacad.com/change-the-column-or-measure-value-in-a-power-bi-visual-by-selection-of-the-slicer-parameter-table-pattern - v-janeyg-msft
Community Support
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
abgnfirdaushai. 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.
- v-janeyg-msft
- Ashish_Mathur
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.
