Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Split the expeses when drill the chart

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

 

2 Replies