Data Labels with Cross Filtering

[newpbiuser01]

Hello,

I have a question about the cross filtering. I have two bar charts showing the data breakdown by different categories. When I click on one of the charts, it filters the other one - which is what we'd expect and also what we're looking for. However, when it cross filters, it only shows the filtered amount (so for the first bar, it only shows $4.3 as opposed to $154.9). My question is, is there a way to show the total too? 

What we currently see is this: 

Would like to show this (without the red boxes 🙂 )

Does anyone know if that's possible

[v-jingzhang · Accepted solution]

Hi @newpbiuser01 

Based on my research, it is not supported to show the totals for columns in a clustered column chart when you cross filter it through another visual. You can raise an idea about this feature at Ideas (powerbi.com) to let the product team know it.  

I have some workarounds as below, hope you will find them helpful. The sample file is attached at bottom. 

Workaround One: Use a stacked column chart and add the other category to Legend. In this way it can always have the total values on top of columns. 

Workaround Two: Create a measure to get the total value without filtering, then add it to the clustered column chart as a second y-axis field. 

Total of Quantity = CALCULATE(SUM('Table'[Quantity]),ALL('Table'[Group]))

Workaround Three: Use a custom column chart along with the total measure from Workaround two. This is similar to Workaround two. 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[newpbiuser01]

Thanks @v-jingzhang! I'll submit my idea, I think it will be helpful to have that feature. But your workarounds (especially the first one) did the trick for me! Thank you 🙂