Forum Discussion
abgnfirdaus
Helper I
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 ...
v-janeyg-msft
Community Support
Community SupportHi, 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
- abgnfirdaus
Thank you so much for your help. Can you help me with this one also.