Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Filter Table Data based on Slicer or Condition

Hello all,   I have created and attached a replication of a desired Report and have the following Problem: I have a Dataset that I want to filter based on the Combination of the Fields t_apac, t_cm...
Need Help
  • lbendlin's avatar
    lbendlin
    3 years ago

    Start small. Create a separate table with the FullSessionName values  and use that for a disconnected slicer.

     

    Then create a measure that implements your logic.  Use that measure as a visual filter for your table visual.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Thanks for the input. I have tried with measures and disconnected tables before but could not make it work.

I had Split the tables into a Module Table and a Session Table and tried to use the measure based on the selected Values in the Slicer

 

Can you please explain/preview how I would manage to do this via measures and disconnected tables? 

 

Thanks and Best Regards

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
3 years ago

Start small. Create a separate table with the FullSessionName values  and use that for a disconnected slicer.

 

Then create a measure that implements your logic.  Use that measure as a visual filter for your table visual.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Thanks. I made it work to always show the Values with "No Session" when it's filtered to a specific Session.