Presentation - Pivot

[MalvikaBhasin]

Hi,

How can I present data in such format in power bi?

Source of my data is:

Regards

Malvika

[Anonymous · Accepted solution]

Hi @MalvikaBhasin ,

Based on my testing, please try the following methods:

1.Create the sample table in excel.

2.Get data from excel in power bi desktop.

3.Drag the column into the bar chart.

4.Set the Bars color in the visualizations.

5.The result is shown below.

Best Regards,

Wisdom Wu

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

[SamWiseOwl]

Hi @MalvikaBhasin 

You should be able to import the data and use it directly in a Matrix visual:

Put type in rows, country in columns and Count of the User Name in the values.

[MalvikaBhasin]

Thanks for the suggestion Sam. However, I wanted a chart - with Country and that bar shows both yellow and green colors. How can I do that?

Regards

Malvika

[MalvikaBhasin]

@ BIswajit_Das - Can you help me with how to translate Pivots in excel in Power BI?