Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

sub group in matrix visualization

Hi All

 as far my knowledge considering matrix visualization , we can't have sub groups or nested grouping ,when we insert context field in column/row  entire matrix groups for the combination of value,  is that correct..?  PBI is more adhoc self service tool or can we think this tool as enterprise for advance reporting..?

 

vs

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    HI Anonymous,

     

    It will be help if you provide the sample data to analysis.
    By default it support to add sub group columns, for example:

     

    Notice: you should ensure these group column has relationship, otherwise it will shows the wrong result.

     

    Regards,

    Xiaoxin Sheng

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      can we get this format in power bi ..?

      three mesaures, quantity, unitprice, calc

      description column

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        HI Anonymous,


        I don't think power bi can auto apply the MTD and YTD on each columns, you should write measures to instead.
        If you can please share sample file for further analysis.

         

        Regards,

        Xiaoxin sheng