Forum Discussion
Data Labels with Cross Filtering
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.
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.
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 🙂