Showing all non-summarized values in a matrix

[Anonymous]

Hi,

I'm looking for a way to present my data in a table/matrix but it looks like it is not possible in Power BI. I've also searched on marketplace but with no success. What I'm trying to achieve is to have a row hierarchy for example for country/state/city. The final hierarchy will have 10+ columns used. The problem is that in a matrix visualization when pressing on the "+" button it only reveals the next row, but I will need to have a specific row always visible (in the example below "city").

Currently in a matrix in order to see the city I would need to open all hierarchy levels ( but "city" needs to be seen at all times). This is what happens when I put "city" in rows. When I put it in values I only get the option to see for example "first city", "last city", "count of cities" but not all of the cities.

Regards

Karol

[amitchandak]

@Anonymous , seems like you need stepped layout. There is option you need switch that on

Refer

https://www.burningsuit.co.uk/blog/2019/04/7-secrets-of-the-matrix-visual/

https://docs.microsoft.com/en-us/power-bi/visuals/desktop-matrix-visual

[Anonymous]

@amitchandak 
No, unfortunately the stepped layout will not solve this issue. The last hierarchy column needs to be avaialable at all times. 

[amitchandak]

With Stepeed layout drill down till the last level and save there.  With reverse Square Y. Hope that will help

[Anonymous]

@amitchandak I assume it is not possible to achieve in Power BI, right? I've researched a lot of marketplace visualizations but haven't found one that would be able to help with this one.

[dax]

Hi @Anonymous , 

Yes, based on my test, I find that this is not available currently in Matrix, I think one workaround is that you could try to use bookmark to achieve this goal, you could refer to  how-to-create-a-bookmark-in-power-bi  for details.

Best Regards,
Zoe Zhi

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

[Anonymous]

@amitchandak This won't solve this problem too. You're suggesting to drill down to the last level and just save it there. In the post, I mentioned that I don't want to see all the levels at all times. Please check the picture I attached and the explaination provided.