Import data with multiple levels

Sorry for the late reply.

I do not see the select all function on powerbi service.

I only see slicer, but it does not allow me to select more than one element and it only allows one field.

Hi sengyap,

You can modify these options at edit report.

Turn off the "single select" option and turn on "select all" option:

Regards,

Xiaoxin Sheng

Yes it works. Thank you.

May I also ask you two more other questions?

How do I minimise the empty space in my embedded map?

Also, I have a 'country' and 'location' column in my dataset. If i enter more than one location in the 'location' field, for example, Java, Jakarta, Bali, will it show up in three different spots on the powerbi map? 

Hi sengyap,

You can modify the width property and height property to resize the embedded map size.

>>Also, I have a 'country' and 'location' column in my dataset. If i enter more than one location in the 'location' field, for example, Java, Jakarta, Bali, will it show up in three different spots on the powerbi map? 

I think it not support this feature.

Regards,

Xiaoxin Sheng

Dear Xiaoxin,

I tried to modify the width and height property like you suggested. I switched it to 800 and 933 width, but the empty space becomes bigger. 680 width will make the report look very small. 

Is there a way to make the report fits the screen like this? I am not sure how the creator did this.

Dear Xiaoxin,

I have a column that contains URL links. However, when I import my data into Powerbi Service, the URL becomes text; there is no hyperlink property.

May I know if there is a way to keep the hyperlink property?

Regards,

Seng Yap

Hi sengyap,

I think you can setting data category to solve this issue.(only power bi desktop support these features)

Regards,

Xiaoxin Sheng

I have one more question. 

I am using the scatter plot function, and for one of the features "play axis", I chose "month". However, it does not sort according to ascending order (i.e., Jan, Feb,..) instead it sorts alphabetically. I tried converting it to 1 (Jan), 2 (Feb), but it still does not sort numerically.

Do you have a solution for this?

I am using powerbi service.