cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
uselvaraj Frequent Visitor
Frequent Visitor

how to group the values in power bi?

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 visualizationgroup powe.PNGPower BIgroup tableau.PNGTableau report

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: how to group the values in power bi?

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

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
MoOv Regular Visitor
Regular Visitor

Re: how to group the values in power bi?

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.

Community Support Team
Community Support Team

Re: how to group the values in power bi?

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

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

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 430 members 4,405 guests
Please welcome our newest community members: