Forum Discussion
Advocate IICreate a custom column from multiple columns with duplicate values to use as a slicer
Jays_D , one what is unpivot the 4 columns and get them into rows
Unpivot Data(Power Query): https://youtu.be/2HjkBtxSM0g
Another one concat 4 columns and create unpivoted dimension
Power BI- Text Part slicer to filter/search text - https://youtu.be/MKKWeOqFG4c
https://medium.com/@amitchandak/power-bi-search-text-parts-in-text-ad2f9783ffa2
Super UserJays_D , one what is unpivot the 4 columns and get them into rows
Unpivot Data(Power Query): https://youtu.be/2HjkBtxSM0g
Another one concat 4 columns and create unpivoted dimension
Power BI- Text Part slicer to filter/search text - https://youtu.be/MKKWeOqFG4c
https://medium.com/@amitchandak/power-bi-search-text-parts-in-text-ad2f9783ffa2
Jays_DThank you amitchandak and apologies for the late repsonse, I had taken some leave.
Unpivoting is new to me but this has solved my issue, thank you for this it's greatly appreciated!