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
tharunkumarRTK's avatar
tharunkumarRTK
Icon for Super User rankSuper User
2 years ago

shlomiwPBI 
I believe you are referring to this error

 

if you want to implement topn at different levels of drill down then you can write a measure and use that measure as a filter in your visual. for ex:

 

I am attaching the file for your reference.

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

 


If the post helps please give a thumbs up


If it solves your issue, please accept it as the solution to help the other members find it more quickly.


Tharun

 

  • 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