Split the expeses when drill the chart

[Anonymous]

Hello,

Need your help!

I want to create a bar chart with 'state' at x-axis and 'Total Expense' amount at y axis. Somthing like this-

The total expense is sum of Direct Expese and Indirect Expense. So when I click on drill down button on bar chart then it will split the values and shows like this-

I tried something to achieve this by creating hierarchy in PBI desktop but somewhere I am making mistakes and not working. Do anyone have any idea to make this happen?

Please advise!

Thanks

Harshad

[v-ljerr-msft · Accepted solution]

Hi @Anonymous,

I don't think there is a way to do it directly with Power BI currently. However, I'm wondering if you could try creating two bookmarks for each chart, and then use a shape/image link to navigate between these two bookmarks to show different states of the chart in your scenario. 

Reference:

Use bookmarks to share insights and build stories in Power BI (Preview)

How to use Bookmarks in Power BI for Seamless Report Navigation

Regards

[Anonymous]

Thanks @v-ljerr-msft

I will give a try with this.

Thanks

Harshad