How I can grouped in column in table on power bi

[marianoz050392]

I want to see the first column grouped but display those different values in the second column.

Or maybe no it´s grouped is a only see once Occidente por example

Thanks

 

[Ashish_Mathur · Accepted solution]

Hi,

Switch to a matrix visual and move both fields to row labels.  Also, drag some measure to the Values well.

[Anonymous · Accepted solution]

Thanks for the reply from Ashish_Mathur and Tahreem24 , please allow me to provide another insight:

Hi, @marianoz050392 
Thanks for reaching out to the Microsoft fabric community forum.

Could you please let us know if Ashish_Mathur's response resolved your issue?I believe Ashish_Mathur's matrix idea is an excellent solution. If it did, kindly accept it as the solution.

1.To facilitate your understanding, I have created the following example:

2.Then, add the required fields to the visual object:

3.Here's my final result, which I hope meets your requirements.

4.For more details, please refer to:

Create a matrix visual in Power BI - Power BI | Microsoft Learn

Can you share sample data and sample output in tabular format if I am misunderstanding? Or a sample pbix after removing sensitive data. We can better understand the problem and help you.When uploading the files, please ensure that any sensitive information is removed to maintain data security

Please find the attached pbix relevant to the case.

Best Regards,

Leroy Lu

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

[Ashish_Mathur · Accepted solution]

Hi,

Switch to a matrix visual and move both fields to row labels.  Also, drag some measure to the Values well.

[Tahreem24]

@marianoz050392  Kindly explain with proper input columns and expected output?