Forum Discussion

nhale's avatar
nhale
Frequent Visitor
5 years ago
Solved

Need help with report filter.

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 clic...
Need Help
  • nhale's avatar
    nhale
    5 years ago

    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.

  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi nhale 

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

    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.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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.

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

Result is as below.

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.

 

nhale's avatar
nhale
Frequent Visitor
5 years ago

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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi nhale 

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

    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.