Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
javiernavarro
New Member

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 sales from last year for these 4 stores

 

I want the bar chart to display all the other stores but the selected one on the first visualization.

Example: Is I select "Store2" in the first table, I would be able to see information in the bar chart only for Store1, Store3 and Store4.

 

Is it possible?

Thank you!

1 ACCEPTED SOLUTION
v-cherch-msft
Microsoft Employee
Microsoft Employee

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] )
    )
)

1.png

Regards,

Cherie

 

 

 

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

View solution in original post

3 REPLIES 3
v-cherch-msft
Microsoft Employee
Microsoft Employee

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] )
    )
)

1.png

Regards,

Cherie

 

 

 

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
LivioLanzo
Solution Sage
Solution Sage

Hello @javiernavarro,

 

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

 

Thank you.

 


 


Did I answer your question correctly? Mark my answer as a solution!


Proud to be a Datanaut!  

Thanks Livio

 

  • This is the two tables Im working with

sales_forum_1.PNG

 

  • 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).

sales_forum_3.PNG

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

 

Thanks again

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.