Forum Discussion

LeahS's avatar
LeahS
Frequent Visitor
3 years ago
Solved

Slicer problems

Hi,   I'm trying to use a slicer for names on my report in the desktop version.  I have a relationship set up with the info table and both data tables on "names."  I used the format of First Name L...
Need Help
  • Ritaf1983's avatar
    Ritaf1983
    3 years ago

    Hi LeahS 

    Did you downloaded the file ? 

    You can follow my steps and see exacly how it works...

    If it is not working in the same way on your model may be there are other problems.

    Please attach dummy pbix and i will look at it 

  • LeahS's avatar
    LeahS
    3 years ago

    I ended up deleting those three tables from my model and then reloading them back in.  Now the slicers work fine.  Not sure what happened the first time.  Thanks for all of your help!

LeahS's avatar
LeahS
Frequent Visitor
3 years ago

Here is the relationships in my table.  I tried what you suggested by creating a measure, but when I click on a name in the slicer, the card still shows "Blank" even though I know that staff has some call outs.

 

Ritaf1983's avatar
Ritaf1983
Super User
3 years ago

Hi LeahS 

Did you downloaded the file ? 

You can follow my steps and see exacly how it works...

If it is not working in the same way on your model may be there are other problems.

Please attach dummy pbix and i will look at it