not able to stack columns in matrix

[thisguy]

I am adding claim type in under date in columns as i want the claim types by month in the data.  but its not showing in the matrix, i googled and from the guides i found this should work so i assume i have a setting wrong but i can't find what it is. 

any ideas?

[thisguy]

omg I drilled down but not far enough - don't mind me i'll be in the corner with my Dunce hat on. 

[selimovd]

@thisguy  never mind, we were all at the point where we didn't see the easy obstacle 😉

Keep going and good luck with the analysis!

[selimovd · Accepted solution]

Hey @thisguy ,

you were pretty close.

At the moment you just see the first level in the hierarchy. Now you have to drill down from Year, to Quarter, to Month, to Day to Claim Type. Click the marked error to drill down and keep the context:

You can also use the double arrow next to it. With this one you will just drill down level by level.

Here it's explained how the drill down works:

Drill down and drill up in a visual - Power BI | Microsoft Docs

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic