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.

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

By default Power BI filters across columns are always applied as AND  (within a column they are applied as OR).  If you want to change that behavior you must implement your own measures across disconnected tables and you must educate your users because the behavior will be unexpected for them.

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.