Forum Discussion
Measure to combine multiple columns for filtering
- Anonymous8 years ago
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
Merry Christmas!
patri0t82,
What list do you refer to? Could you please post a screenshot of the current status?
Regards,
Lydia
- Anonymous8 years agoNot applicable
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 - patri0t828 years ago
Post Patron
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?
- patri0t828 years ago
Post Patron
Hi again, I'm sorry to re-respond, but that link you provided.. I just found myself more confused when I started working with it. When people fill out their entry form, they can choose from a list of hazards, which are each columns in my table.
While each hazard has its own column, there is also a column records this 'generic' hazard as a record. Ie: vehicles, uneven ground, etc.
I was able to create a new table from these responses somehow, but I'm not sure if it helps:
Now, in my main table, as I said there is a column header for each 'generic' hazard. In those columns are all the 'specific' hazards that people can choose from. Here is an example below:
I'd like to create a slicer, somehow. Something that lets me choose a general hazard and then shows me all of the specific hazards within that general hazard that people have entered. I can't figure out how to make them all work together.