Calculating percentage of level above in matrix and displaying on line chart?

[Lumpypillow]

Hi Experts,

I am very new to PowerBI and am trying to basically create interactive line charts for layers of data with cellular data. This is more related to science than buiness but the concept should be the same. I have the data in a table like below: 

I created a hierarchy from this table into a matrix where I would like to display the count at each level and the percetange compared to the level above.

PowerBI however is calculating the % of the grand total but I would like to have it calculate values compared to just the level above, not from the total count. Finally once I have that done I would like to be able to display those percentages on a line chart that filters as I drill through levels. Any help would be greatly apprecaited!

[Lumpypillow]

Works great, thanks!

[NaveenGandhi · Accepted solution]

Hi @Lumpypillow 

Check the attached PBIX.

Let me know if this works.

If this post helps, then please consider Accept it as the solution to help the others find it more quickly. Appreciate you kudos!!

Follow me on LinkedIn!!!


LinkedIn