how to group the values in power bi?

[uselvaraj]

Hi ,

I am trying to create a power bi replicating the tableau report. In tableau, it automatically group the values when we place the columns in rows pane. But in Power BI, i am not able to group the exact same way of tableau report. Please help me how to group the values in report pane of power bi. I have tried table and matrix visualizationPower BITableau report

[v-lili6-msft · Accepted solution]

hi, @uselvaraj 

You could get it by using Matrix visual in power bi, just set up the right hierarchy and then use drill down with the matrix visual

https://docs.microsoft.com/en-us/power-bi/visuals/desktop-matrix-visual

Best Regards,

Lin

[Anonymous]

The matrix visual provides this functionality. Just add Region, Brand and JurisdictionID as rows and Customer Count as values, and expand the rows. The result will not look exactly like in your example, but close to it.