De composition tree chart order and final expand result not proper

[saivina2920]

I am developing de composition chart for my one of the esteemed project.

My chart order  is currently like below.

But, i want Dept columns as vertical order instead of horizontal order.

pls. find the sample Pbix files and data excel as mentiond below.

Pls. refer the second sheet (conditions) for final expand result.

Test File ==> https://1drv.ms/f/s!AiSRcgO5FUmN8hfMadot49lN72hh?e=INKSOa 

pls. help how to achieve this. this is very very urgent.

[v-xinruzhu-msft]

Hi @saivina2920 

After testing, this decomposition tree is arranged horizontally, and there is no way to set it vertically for the time being.

You can refer to the following link.

Decomposition tree - Power BI | Microsoft Learn

Best Regards!

Yolo Zhu

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

[saivina2920]

Thanks for your reply.

In that case (there is no way to set vertically), 

How do we arrive the below mentioned result (Highlighed Arrow) when excellent expanded...?

pls. suggest or modify my .pbix files like above highlighted..

[v-xinruzhu-msft · Accepted solution]

Hi @saivina2920 

You can unpivot the table first in power query

Then create a new calculated column

Column =
SWITCH (
    TRUE (),
    [CODE] = BLANK ()
        && [VALUE] = BLANK (), "Code & Value Blank",
    [CODE] <> BLANK ()
        && [VALUE] <> BLANK (), "Code & Value Non Blank",
    [CODE] <> BLANK ()
        && [VALUE] = BLANK (), "Code No Blank and Value Blank",
    [CODE] = BLANK ()
        && [VALUE] <> BLANK (), "Value No Blank and Code Blank"
)

Best Regards!

Yolo Zhu

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

[saivina2920]

Hi @v-xinruzhu-msft ,

Thanks for your awesome output and sorry for the late reply.

Is is possible to show the percentage with count in De composition all the tree nodes....?

Important Note : Total Records will  be 16 and the expansion node will based on that. How it will come 40..could you pls. explain this...?

pls. reply this is very very urgent.