Slicer with distinct values from a column that has multiple values?
I'm very much a novice when it comes to PowerBI, so please be gentle here. I have an issue where I have a column named specifications in my item master table that has multiple different specs for each item ID,
example: item ID - "2778-FR" has specs: FDA Approved, RGD, GFLT, etc.
item ID - "3489-GT" has specs: UP, Dupont Viton, Class VI, FDA Approved, etc.
What I want to do is have a slicer dropdown that picks out the distinct values from this spec column and then what ever is picked from this slicer will filter the data table below it with the corresponding items that have those specifications.
You need to have all distinct spec values in a column of an independent table and use this column in a slicer. Then create below measure and drag it into the table visual's filter pane and set value is 1.
VAR selectedSpec = SELECTEDVALUE(specifications[spec])
VAR Specs = SELECTEDVALUE('master table'[specifications])
Download the attachment for details.
Regards, Community Support Team _ Jing If this post helps, please Accept it as the solution to help other members find it.
0608_Slicer with distinct values from a column that has multiple values.pbix
This worked perfectly! Thank you so much for your help! One quick question and its not the end of the world if this is not possible but it doesn't seem to filter properly on multiple spec selections, would that be possible to filter on multiple specs?