Cluster bar chart - 2 measures - click each bar to show values individually

[vinaydavid]

Hi Experts,
I have a situation where I need to show 'avg sales' in one bar and 'sales' in another bar of a cluster bar chart.
Requirement is to click and see 'avg sales' - separately
Click and see 'sales' separately
Both avg sales and sales are 2 measures that I have. Need to show these on a single dimension.

Please help me with some ideas /suggestions. Struggling as I am new to power bi.
Thanks

[v-xicai]

Hi @vinaydavid ,

You can use "Edit interactions" button to implement your demand following steps below. For example:

You can learn more: https://docs.microsoft.com/en-us/power-bi/service-reports-visual-interactions

Best Regards,

Amy

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