Forum Discussion
Slicer Callouts Based on Contents in Another Table
HI, I have a table with account information including a column with state abbreviations; the accounts listed do not span the entire 50 states. I've created another table to list state abbreviations with full state names, and created a relationship between the two tables. I've also created a slicer to filter by state; the slicer works using either the abbreviated state column in the account table or the full state name in the second table. When I use the abbreviated state column the slicer only includes states that have accounts in them; when I use the full name column the slicer includes all states, whether there are accounts or not. I would like the user to see the full state name in the slicer, but only for those states that have accounts. Is there a way to do this?
Here's a clip of the tables with the relationships
Here's a shot of the slicer using abbreviated state
Here's a shot of the slicer using full name state
- Anonymous2 years ago
Hi MikeThoreson
You can create a measure.
Measure = IF ( MAX ( DIMCustomerTable[Account] ) <> BLANK (), 1, 0 )Then put the measure to the slicer visual filter, then it can only display the name with existed account.
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Yolo, thanks so much, that worked great!
2 Replies
- AnonymousNot applicable
Hi MikeThoreson
You can create a measure.
Measure = IF ( MAX ( DIMCustomerTable[Account] ) <> BLANK (), 1, 0 )Then put the measure to the slicer visual filter, then it can only display the name with existed account.
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- MikeThoresonFrequent Visitor
Yolo, thanks so much, that worked great!