Forum Discussion
Presentation - Pivot
Hi,
How can I present data in such format in power bi?
Source of my data is:
Regards
Malvika
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.
4 Replies
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.
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.
@ BIswajit_Das - Can you help me with how to translate Pivots in excel in Power BI?
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
