Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

not able to stack columns in matrix

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 ...
Need Help
  • selimovd's avatar
    selimovd
    5 years ago

    Hey Anonymous ,

     

    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
     
selimovd's avatar
selimovd
Most Valuable Professional
5 years ago

Hey Anonymous ,

 

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