Forum Discussion

MikeThoreson's avatar
MikeThoreson
Frequent Visitor
2 years ago
Solved

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

 

 

 

  • Anonymous's avatar
    Anonymous
    2 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.

     

     

2 Replies

  • Anonymous's avatar
    Anonymous
    Not 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.

     

     

    • MikeThoreson's avatar
      MikeThoreson
      Frequent Visitor

      Yolo, thanks so much, that worked great!