Forum Discussion

sengyap's avatar
sengyap
Helper I
9 years ago

Import data with multiple levels

In the tutorial video, the microsoft guy was able to import data with different levels (e.g., he was able to break down geography into cities and countries, and break down products into different typ...
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi sengyap,

 

>>In the tutorial video, the microsoft guy was able to import data with different levels (e.g., he was able to break down geography into cities and countries, and break down products into different types of products).

Since I'm not very clear your requirement, can you share us some detail information about this?

 

In addition, if you want to group by product type, you can follow below steps to prepare data.

 

Table:

 

 

Create visuals.

Matrix:

 

 

 

Regards,

Xiaoxin Sheng

sengyap's avatar
sengyap
Helper I
9 years ago

Sure. I am referring to this video tutorial https://powerbi.microsoft.com/en-us/guided-learning/powerbi-learning-3-2-create-customize-simple-visualizations/.

 

I am not sure how he was able to break down the "geography" category into so many city, country, district, and the "sales" categoy into revenue, units, YTD revenue.

 

 

When I import my data, my "country" data cannot be broken down into the respective countries, such as Indonesia, Cambodia.

 

Also, how was he able to connect to so many datasets in a single report?