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

Occurrence of a text in a new column

Hi,

I am new to Power BI and I want to create a chart comparing the number of skyscrapers for each country.

My table looks like thi
s.

 

Building NameCountry
Burj KhalifaAE
Shanghai TowerCN
Makkah Royal Clock TowerSA
Ping An Finance CenterCN
Lotte World TowerKR
One World Trade CenterUS
Guangzhou CTF Finance CentreCN
TAIPEI 101TW
Shanghai World Financial CenterCN
International Commerce CentreCN
Changsha IFS Tower T1CN

 

 

Thank you.

1 ACCEPTED SOLUTION

Accepted Solutions
Thejeswar Senior Member
Senior Member

Re: Occurrence of a text in a new column

Hi,

Simply drag and drop the columns in your power BI desktop.

 

Set the property of Building Name to Count. Then select the chart visual that you need.

You wil get the needed look. the Same is shown belowtab1.PNG

 

1 REPLY 1
Thejeswar Senior Member
Senior Member

Re: Occurrence of a text in a new column

Hi,

Simply drag and drop the columns in your power BI desktop.

 

Set the property of Building Name to Count. Then select the chart visual that you need.

You wil get the needed look. the Same is shown belowtab1.PNG