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
Post PatronHey, 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?
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!