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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
nhale
Frequent Visitor

Need help with report filter.

nhale_0-1628111517673.png

Trying to figure out something that should be simple.  The chart on the top is showing goods sold for 5 different products in 7 different regions.   Each region has 7 to 10 stores.  When I click on product B in region 2 in the chart above is there a way to then populate sales by store in region 2 for product B in the smaller chart below when I select that bar above.   I have incorporated into my data model a table that lists the store numbers in each region.  Many thanks for anyone that can point me in the right direction.

2 ACCEPTED SOLUTIONS

Thanks for your help.   I was able to get that working, but above you have selected one column of the cluster (Product B for region 2)   That's exaclty what I want to do but I don't have the ability to select the individual columns in region 2.  I must have missed something.    Thanks.

View solution in original post

Hi @nhale 

Check your visual format. Add Region in Axis, Product in Legend and Sales in Values in your cluster column chart.

1.png

Download the latest version of Power BI Desktop and try again. 

You can download my sample file and check the differences between you and mine.

 

Best Regards,
Rico Zhou

 

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

4 REPLIES 4
v-rzhou-msft
Community Support
Community Support

Hi  @nhale

In addition to lbendlin 's reply, use Edit interactions in Format Tab and change cross-highlighting in small visual to cross-filtering.  

I build a sample to have a test.

Build two visuals like yours.  Click on Edit interactions.

2.png

Then select cluster column chart and select left icon(Cross-filter) in small visual.

3.png

Result is as below.

3.png

For reference: Change how visuals interact in a Power BI report

 

Best Regards,
Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Thanks for your help.   I was able to get that working, but above you have selected one column of the cluster (Product B for region 2)   That's exaclty what I want to do but I don't have the ability to select the individual columns in region 2.  I must have missed something.    Thanks.

Hi @nhale 

Check your visual format. Add Region in Axis, Product in Legend and Sales in Values in your cluster column chart.

1.png

Download the latest version of Power BI Desktop and try again. 

You can download my sample file and check the differences between you and mine.

 

Best Regards,
Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

lbendlin
Super User
Super User

Change the default behavior from cross highlighting to cross filtering.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors