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 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- patri0t82
I'm sorry it's so hard to explain..
I'll try to word it carefully because I'm not sure what I could take a picture of.
I have a series of columns. ie: Scaffolding, PPE, Product on Ground.
In the Scaffolding column, I have results like:
Adjusted
Untidy
Tripping Hazard
In the PPE column, I have results like:
Needs adjusting
Inadequate for job
Soiled PPE
In the Product on Ground column, I have results like:
Oil
Water
Chemical
I've been able to successfully merge all the columns together and create one big list of all the individual items:
Adjusted
Untidy
Tripping Hazard
Needs adjusting
Inadequate for job
Soiled PPE
Oil
Water
Chemical
What I would like to do, though, is select a column header (one of the three above, for example), and then the individual results from that column. Or, select all of them.
Does that make a little more sense?