Total Bar in Hierarchical Bat Chart

[Chirag4370]

I'm Trying to display Sub Total and Grand Total in Hierarchical bar chart.

[Chirag4370]

I have created similar kind of situation using dummy data. refer below link to get .pbix file. 

https://drive.google.com/file/d/1pxEZDFeoR_8LqGJfMdDcNQCN6O2D2YXI/view?usp=sharing

[MFelix]

Hi @Chirag4370 ,

It's asking for password to access the file.

[Chirag4370]

@MFelix 

Sorry for that. Now you can check. 

[MFelix]

Continues to ask password.

[MFelix]

Hi @Chirag4370 ,

Can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.

If the information is sensitive please share it trough private message.

[Chocohammer]

HI @Chirag4370 

My guess is there is no relationship with the Date. So, if you add a second X-axis with Date, then the total looks weird.

Do I understand corretly, you are triyng to make the Total out of combination EEE and Other?

Have a good one

Choco

[Chirag4370]

I forgot to mation that, but DateText table also has relation with Data table. and alson sorted.

Yes, I want the combined total which is already found. Now if you see the category (EEE & Other) wise total also displayed combined total instead of category wise. I'm trying to get category wise total.

[Chocohammer]

Try to use the Filters like this: 

I don't know how your axis are named so hope you will get the idea.

[Chirag4370]

Total bar repeat Grand total in all three categories (EEE, Other & Total). I'm trying to get category wise Total in EEE and Other and Grand Total as 3rd category Total.