Make Visual With Hirarcy table

[adminPBI]

Hi,

my boss told me to make visual data with a visual matrix on power bi

for data like what I have screen shot and what my boss wants is to make visuals like those on paper.

I've tried to made it and the results like this

He wants Status 3 and 1 can do hirarcy and the rest of it cannot do that.

How do I make the visuals on the matrix the way my boss wants?

any suggestion?

BR,
AdminPBI

[v-eachen-msft · Accepted solution]

Hi @adminPBI ,

You could do it with the following measure.

value measure =
IF (
    SELECTEDVALUE ( 'Table'[Column1] ) = "A",
    SUM ( 'Table'[Value] ),
    IF ( NOT ( ISINSCOPE ( 'Table'[Column2] ) ), SUM ( 'Table'[Value] ) )
)

Here is the result.

Here is my test file for your reference.

[Anonymous]

hi,
how about this one,
is this possible to build something like this?
i want to build a visual that can do like this
in step 1 and step 2 will be a diffrent valuesBR,
faishal abdillah