Forum Discussion

learner_23's avatar
learner_23
Frequent Visitor
2 years ago

help for beginner power bi

Hi,   I am new here. I am struggling with the requirement to create a simple bar chart and table. I attached excelsheet. Sheet 1 is my data and sheet 2 is expected visualization. Can help to create...
Need Help
Show and Tell
Uzi2019's avatar
Uzi2019
Icon for Community Champion rankCommunity Champion
2 years ago

Hi learner_23 


Just take your values in x axis and Y axis and change the aggregation from Sum to count on Y axis value. I have taken your sample data. chec the screenshot below

 

 

You dont have to do any transformation on your data. I've taken your data as it is.

you can see the result. 


I hope I answered your question!