Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Nested Rows in Matrix

I have 4 different tables: Location, Product, Year and Sales Fact.

I need to create a nested Matrix as below:

 

 

I am able to create Column Level Nesting.

But I am not able to create Row Level Nesting between Location and Product.

 

Need help in achieving this.

 

 

Need Help

5 Replies

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    7 years ago

    Hi Anonymous 

    If you have four tables as mine and create relationships as below

    Then you could add columns in matrix visual and get the expected output.

    Please find more details in my pbix file.

     

    Best Regards

    Maggie

     

    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi v-juanli-msft 

       

      Is there any particular property that needs to be set?

      I already had joins inplace, but I am not getting the desired output.

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

      Above is the output that I am getting.

       

      Thanks,

      Ravin

      • v-juanli-msft's avatar
        v-juanli-msft
        Community Support
        7 years ago

        Hi Anonymous 

        The cross filter direction between "Product" and "Sales fact" should be "both" instead of "single".

         

        Best Regards

        Maggie

         

        Community Support Team _ Maggie Li
        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.