Forum Discussion

freddyford's avatar
freddyford
Regular Visitor
7 years ago
Solved

Grouping Data like Tableau

Hello All,   I'm new to Power BI and wanted to know how to replicate a feature in tableau that groups data. (Im using Power BI and not tableau as Tableau lacks some functionality I need)   When l...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi freddyford

    This feature is also available in PowerBi, you need to select Matrix visual instead of Table and in the format pane you need to off steeped layout option.

  • Thejeswar's avatar
    Thejeswar
    7 years ago

    Hi freddyford,

    As per my understanding you can't group the data in case of a table in power bi.

     

    Instead you can use a matrix that will help group the data as per your need. 

     

    Assume, In case of two columns namely Category and Material. Add them to the Columns and Expand all down one level and then Switch off Stepped layout in the matrix visual "Row Headers"

     

    See the screenshot below for the same

     

     

     

Thejeswar's avatar
Thejeswar
Super User
7 years ago

Hi freddyford,

As per my understanding you can't group the data in case of a table in power bi.

 

Instead you can use a matrix that will help group the data as per your need. 

 

Assume, In case of two columns namely Category and Material. Add them to the Columns and Expand all down one level and then Switch off Stepped layout in the matrix visual "Row Headers"

 

See the screenshot below for the same