Hierarchy Tree with Comparison Bar Visuals

Anonymous — Tue, 07 Jun 2022 12:36:44 GMT

Hi,

I am trying to create a Hierarchial Tree like Visual in Power BI. It will have one slicer with list of Customer CIF's, based upon the slicer selected the values in the Tree should change. My requirement is to show two bar like visual in each tree category for the Customer CIF selected in the slicer

one bar should show total amount for that CIF selected in slicer
Another bar should show sum of the amount of all other CIF's except the CIF selected in the slicer

I tried with Decomposition Tree visual, but it is not accepting more than one measure to show the comparision. Even tried with some custom visuals, but didnt find anything with two bar's, Every visual has one bar + value of the other measure.

Any help on these would be really helpful.

Below is the screenshot of report requirement:

Re: Hierarchy Tree with Comparison Bar Visuals

Anonymous — Fri, 10 Jun 2022 01:32:47 GMT

Hi @Anonymous,

I check the power bi visuals but have not found a visual similar to your excepted results. (hierarchy tree - xViz maybe help but it is not fully simpler to your requirement)

For this scenario, maybe you can take a look at the custom visuals in the app store or try to use script-based visuals(R, Python) to manually plot these graphs.

Business Apps – Microsoft AppSource

Create Power BI visuals using R - Power BI | Microsoft Docs

Create Power BI visuals using Python in Power BI Desktop - Power BI | Microsoft Docs

Regards,

Xiaoxin Sheng

topic Hierarchy Tree with Comparison Bar Visuals in Developer

Hierarchy Tree with Comparison Bar Visuals

Re: Hierarchy Tree with Comparison Bar Visuals