Forum Discussion

shlomiwPBI's avatar
shlomiwPBI
New Member
2 years ago
Solved

Dynamic dimension to Column chart drill mode

Hi guys   I have a coulumn chart with DRILL mode to drill down by dimension I also wat to show only top10 values   The issue is that when I drill down, I still want to see the top10 values of th...
Need Help
shlomiwPBI's avatar
shlomiwPBI
New Member
2 years ago

Thanks Tharun
It seems to wok fine with 2 levels in the hierarchy, can you send the example for 3 or more levels?
i need 4 levels in my hierarchy

 

Shlomi

 

shlomiwPBI's avatar
shlomiwPBI
New Member
2 years ago

Another issue is that in this solution the numbers that I see in the top level are not correct, it shows only the sum of the first top 3 values of the lower level and I don't what the numbers to change

 

Let's assume that Customer A has a total sales value of 1000 USD
Devided into 4 Products:
Prod 1 = 300 USD
Prod 2 = 300 USD
Prod 3 = 300 USD
Prod 4 = 100 USD
in this soultion I will only see total sales of 900 USD in the upper Customers level which is wrong 😞
The sames goes to the next lower levels I assume 

Thanks

Shlomi