Forum Discussion
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 types of products).
If I have a column, e.g., products, in my excel file, how should I prepare the data so that when I import into Power Bi Service, it can be broken down into different types of products (such as cameras, wheels, tablet)?
18 Replies
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
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?
Hi sengyap,
>>When I import my data, my "country" data cannot be broken down into the respective countries, such as Indonesia, Cambodia.
Did you make sure the country field's data category is correctly identified to city or state or province?
If not, you should manual modify it.
In addition, you should drag your "geography" column to legend file to group the data.
>>Also, how was he able to connect to so many datasets in a single report?
You can use get data button to add multiple datasource which from different place.
Regards,
Xiaoxin Sheng
