Do not show hierarchy level on a case-by-case basis in matrix

[orlando9427]

Hi,

I am currently working with a matrix that shows the sales information by tiers (Level 1, Level 2, Level 3, Level 4), but only in one situation do I need Level 3 to be skipped.

How it is currently displayed is

Level 1 - A	15
Level 2 - A	15
Level 3 - A	10
Level 4 - A	5
Level 4 - B	3
Level 4 - C	2
Level 3 - B	5
Level 4 - A	5
Level 2 - B	10
Level 3 - A	10

What I'm looking for is only when Level 2 equals A not show Level 3 looking like this

Level 1 - A	15
Level 2 - A	15
Level 4 - A	10
Level 4 - B	3
Level 4 - C	2
Level 2 - B	10
Level 3 - A	10

The data contains the level information in the same row.

Level 1	Level 2	Level 3	Level 4	Quantity
A	A	A	A	10

Is there a way to accomplish this?

Thanks in advantage.

[Anonymous · Accepted solution]

Hi @orlando9427 

Unfortunately, Power BI's default settings might not directly support conditional hierarchy level display.

Maybe you can try creating a calculated column in your data model that conditionally returns the value for Level 3 based on the value of Level 2. The DAX formula for this calculated column could look something like this:

Level 3 Custom = IF('Table'[Level 2] = "A", BLANK(), 'Table'[Level 3])

This formula checks if Level 2 equals "A", and if so, it returns a blank value for Level 3; otherwise, it returns the original Level 3 value.

Instead of using the original Level 3 column in your matrix, use the newly created calculated column . This way, when Level 2 equals "A", Level 3 will effectively be skipped (displayed as blank), aligning with your requirement.

Best Regards,

Jayleny

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