Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Slicer across multiple datasources

Hello, I have two datasources one at weekly and other at monthly. Wanted to use a filter that is common in both the tables as selector that will drive both the tables.   Have tried sync slicers o...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    6 years ago

    Hi Anonymous 

    I create a new "Table", use it in a slicer, i create a measure to show selected value (monthly/weekly).

    selection = SWITCH(SELECTEDVALUE('Table'[slicer]),"weekly",SUM('weekly table'[weekly value]),"monthly",SUM('monthly table'[monthly value]))

     

    Best Regards
    Maggie
    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous 

I create a new "Table", use it in a slicer, i create a measure to show selected value (monthly/weekly).

selection = SWITCH(SELECTEDVALUE('Table'[slicer]),"weekly",SUM('weekly table'[weekly value]),"monthly",SUM('monthly table'[monthly value]))

 

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.