Create 3 levels in chart but value should not rollup

[Anonymous]

Hi All

I want to create column chart in Power BI and want to show 3 levels (Region, Area, Terr). When the user will click on any region then all areas should visible which are belong to selected region. Normally, its happend in th PowerBI, if, values are rolling up. Like, SUM of all territories are creating area and SUM of areas are related to region.

But, in my case, i have different values for all roles. Please suggest, how i can achieve it

KInd Regards

Ashwani

[mwegener · Accepted solution]

Hi @Anonymous 

you mean something like this?

PBIX

If I answered your question, please mark my post as solution, this will also help others.

Please give Kudos for support.

[Anonymous · Accepted solution]

Thank you so much @mwegener 

It is exactly which i required. I am loving it... Thank you so much!!

Kind Regards

Ashwani

[mwegener]

Hi @Anonymous 

If I answered your question, please mark my post as solution, this will also help others.

Please give Kudos for support.

[mwegener · Accepted solution]

Hi @Anonymous 

you mean something like this?

PBIX

If I answered your question, please mark my post as solution, this will also help others.

Please give Kudos for support.