Forum Discussion
Post PatronMeasure to combine multiple columns for filtering
patri0t82，
Please follow the guide in the knowledge base below to create table and measure .
https://community.powerbi.com/t5/Community-Knowledge-Base/Dynamic-column-based-on-slicer-selection/ta-p/162635
Regards,
Lydia
patri0t82,
Select the columns in your table and click "Merge Column" under Tranform ribbon to merge your columns.
Additionally, I am not clear about your requirement that count number of instances for each text string, could you please share sample data of your table and post expected result?
Regards,
Lydia
Post PatronHi, thanks for helping me with that, it's certainly helped me achieve my goal! It's combined all the results of those columns so I can choose from one slicer. That's exactly what I needed.
Still, I'd also like to be able to combine the headers only from those columns into one slicer. Is there any way to merge column headers?
patri0t82，
Could you please describe more details about "merge headers"? When you use merge columns, the headers are also combined.
Regards,
Lydia- patri0t82Hey, thanks again for responding. In my first post, I listed all the column headers. When I merged the columns, I'm not sure they appeared in the list... Only the results in those columns.
Merry Christmas!patri0t82,
What list do you refer to? Could you please post a screenshot of the current status?
Regards,
Lydia