Forum Discussion
attribute slicer based on multiple columns
Couldn't figure out exactly how to do it like I thought I wanted, but the end result works great!
I left as three separate columns, with a single character designating the type. I set the two "Yes/No" columns from my query to either have the value, or be null. Then, I created three new tables with the short characters used in my main data table, along with "prettified" names for use in the slicers. I set the relationships to crossfilter both ways, and created three slicers, but grouped them together so they looked like they belonged together. Creating the extra tables eliminated buttons showing for both "Yes" and "No", and now it will either filter it to the equivalent of the "Yes" answers, or not filter that column at all.
How about creating a new column and filter against this column?
Column = IF('Table'[Day Shift]="Yes"&&'Table'[Salaried]="Yes",'Table'[Job]&"--"&"Day shift"&"--"&"Salaried","Other")
Couldn't figure out exactly how to do it like I thought I wanted, but the end result works great!
I left as three separate columns, with a single character designating the type. I set the two "Yes/No" columns from my query to either have the value, or be null. Then, I created three new tables with the short characters used in my main data table, along with "prettified" names for use in the slicers. I set the relationships to crossfilter both ways, and created three slicers, but grouped them together so they looked like they belonged together. Creating the extra tables eliminated buttons showing for both "Yes" and "No", and now it will either filter it to the equivalent of the "Yes" answers, or not filter that column at all.