Only show values in matrix for the 'lowest level'

[BeVries]

Hello all,

I have a small problem using matrix visuals.

I made a matrix using three layers:

- City

- Complex

- Unit

The problem is that the matrix shows values for the City and Complex, which are misleading. I ONLY want to show the values for the lowest level 'Unit'.

I turned row and column totals off, but they still show when the rows aren't selected/opened:

What I want is that the part in red (the 'closed' levels of the matrix) just show the name of the City, but not values until I open those to the level of Unit.

I clicked through everything, looked everywhere, but I cannot seem to find it. Is this possible?

[BeVries · Accepted solution]

I sort of found my solution using ISINSCOPE()

When I use a measure like this:

Matrix EP2 Tonen =
IF(
ISINSCOPE(
DIM_Objecten[adres_compleet]
),
MAX(laatste_registratie[EP2]),
BLANK()
)

It works...

But I feel like it is a bit weird to do this for all my columns... Is this really the only way to do this?

[Anonymous]

Hi @BeVries 

I'm glad to hear that you solved the problem. Could you please mark your solution as an ANSWER? This will help more users who are facing the same or similar difficulties. Thank you!

I'm afraid this is the only way, and Power BI currently does not support this effect through settings. But I think your idea makes sense and you can submit an idea for it at: Home (microsoft.com) and wait for users with the same needs as you to vote for you to help make it happen as soon as possible.

Hopefully this will be possible in a future release.

Best Regards,
Yulia Xu

[Joe_Barry]

Hi @BeVries 

Hover over the right side of the matrix and choose this option until you find the level you need.

Joe

[BeVries]

Thanks, but that is not wat I need.

I want to keep the three levels closed until needed.

My users should be able to quickly find the right city and click to the next level. But at that level (and the level of Complex) the matrix should not show data avareges. It show just be blank until the user reaches the lowest level of Unit.

I can't keep this lowest level open all the time since there is a lot of data.