Forum Discussion

javiernavarro's avatar
javiernavarro
New Member
7 years ago
Solved

Filters between visualizations

Hello everyone,   I have two differents visualizations. In one of them (table) I have this column   STORES Store1 Store2 Store3 Store4   In the other visualization (bar chart) i have the sa...
Need Help
Show and Tell
Tips and Tricks
  • v-cherch-msft's avatar
    v-cherch-msft
    7 years ago

    Hi javiernavarro 

     

    You may create a slicer table and use it as slicer.Then create a measure like below.Attached the sample file for reference.

    Sales 2018 =
CALCULATE (
    SUM ( Table1[Sales] ),
    FILTER (
        Table1,
        Table1[Year] = 2018
            && Table1[Store Branch] <> SELECTEDVALUE ( 'Table'[Store Branch] )
    )
)

    Regards,

    Cherie

     

     

     

LivioLanzo's avatar
LivioLanzo
Solution Sage
7 years ago

Hello javiernavarro,

 

this is possible, can you post a sample of your dataset?

 

Thank you.

javiernavarro's avatar
javiernavarro
New Member
7 years ago

Thanks Livio

 

  • This is the two tables Im working with

 

  • I have made a bar chart using the second one. Right now if I select Store4 in the first one, the Store4 row gets highlighted in the second visualization (as shown below).

I want the bar chart to highlight the other rows, not the selected one.

 

Thanks again