topic Re: Decomposition Tree show both (Numbers & Percentage) in Developer

Decomposition Tree show both (Numbers & Percentage)

Ahmed_Khalil — Wed, 22 Feb 2023 21:17:18 GMT

Hi,

while im using Decimposition Tree visual i've noticed that i can show the value Numbers OR Percentage not both side by side

what i need is for example showing the value like this : 120,000 (39%)

thanks in advance for your support

Re: Decomposition Tree show both (Numbers & Percentage)

v-jianboli-msft — Fri, 24 Feb 2023 01:40:11 GMT

Hi @Ahmed_Khalil ,

Accroding to my knowledge, Currently Decomposition Tree does not support show both number and percentage at the same time.

An idea similar with what you expect has been submitted here, please vote it up and you can add comments.

If an idea is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.

Maybe you can use tooltips to achieve your goal, here is my sample:

Create a measure percentage:

Percentage = var _a = SUM('Table'[Column1])/CALCULATE(SUM('Table'[Column1]),ALL('Table')) return _a

Then apply it to the tooltips:

Final output:

For more details, please refer to:

Customizing tooltips in Power BI Desktop - Power BI | Microsoft Learn

Best Regards,

Jianbo Li

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

Re: Decomposition Tree show both (Numbers & Percentage)

v-jianboli-msft — Wed, 01 Mar 2023 06:43:12 GMT

Hi @Ahmed_Khalil ,

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or if you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file after removing sensitive data.

Refer to:

How to provide sample data in the Power BI Forum

How to Get Your Question Answered Quickly

Best Regards,

Jianbo Li

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

Re: Decomposition Tree show both (Numbers & Percentage)

Ahmed_Khalil — Wed, 01 Mar 2023 08:26:09 GMT

Hi Jianbo Li,

thanks for your Help but unfortunately this solution doesnt solve my issue because direct report dont want to use tooltip, they just want to see the full image by glance because its many parameter with many atribiutes.

your solution will be much better incase its small data.

but for sure thanks for your support