cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
Highlighted
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
Highlighted
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

 

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

Top Ideas
Users Online
Currently online: 6 members 1,855 guests
Please welcome our newest community members: