Forum Discussion

bsas's avatar
bsas
Post Patron
2 years ago
Solved

Create measure as a filter to dynamically filter data based on slicer selection

Hi Community! Have tricky task to filter chart based on dynamic slicer selection with conditions. In slicer I have Scenario label from scenarios table (see table below and image), each label value...
Need Help
Show and Tell
  • bsas's avatar
    bsas
    2 years ago

    Hi @Ibendlin, I have complex data model with 3 fact tables 2 period slicers and 2 scenario slicers, can't use this approach as slicer should be synched across all pages and there is logic based on it in measures. But I've managed to find out anouther solution - create calculated table based on GENERATESERIES, use it as a slicer and calculations so user can have possibility choose how many scenarios wants to see regardless selected scenario in slicer.

lbendlin's avatar
lbendlin
Super User
2 years ago

Don't mess with the interactions. Instead, use a disconnected table for the slicer and your measure based on its selection.

bsas's avatar
bsas
Post Patron
2 years ago

Hi @Ibendlin, I have complex data model with 3 fact tables 2 period slicers and 2 scenario slicers, can't use this approach as slicer should be synched across all pages and there is logic based on it in measures. But I've managed to find out anouther solution - create calculated table based on GENERATESERIES, use it as a slicer and calculations so user can have possibility choose how many scenarios wants to see regardless selected scenario in slicer.