Create measure percentages hierarchical scheme

[Syndicate_Admin]

Hello!!

I have a hierarchical schematic graph. Each level records the number of transactions and the percentage of total transactions.

Currently the percentage shown in the information corresponds to the percentage of the category by level over the overall total, in this example 889/1930 = 0.4606, which is fine.

I want to add another percentage that includes the value of the category by level over the total (sum) of the peer category. For example, in Level 2, the percentages should be:

Agent: 889/1041

WApp: 115/1041

SMS: 37/1041

 

For Level 3, it would be something like:

Agent hours: 731/889

Out of hours agent: 158/889

I want to create a single measure that shows me those percentages to include them in the information space that is displayed when I place the pointer on the object, it has been difficult for me considering that each level is a different column.

Thank you for your help.

[v-yangliu-msft · Accepted solution]

Hi  @Syndicate_Admin ,

Click Get more visual.

Inside the search box – Hierarchy Tree – Add the custom Visual.

Result：

For more information on Hierarchy Tree Visual, please refer to the following link

xViz Hierarchy Tree/Advanced Decomposition Tree - Power BI Visual

Hierarchical Tree/Advanced Decomposition Tree for Power BI - Features (xviz.com)

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.