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 This would be pretty straightforward in the Query Editor with the options to combine columns. But the DAX method has been answered here.- https://community.powerbi.com/t5/Desktop/help-how-to-merge-2-columns/td-p/53920
patri0t82Hey, thanks for replying. I tool a look at merging the query, but I'm not sure it's the right approach. Under each of those headers, I don't have a count, or number - I have other text strings. I'd like to be able to filter by header and then again count the number of instances for each text string. Does that make sense?
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- patri0t82
Hi, 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?