How to design nicely and reasonably

[kimlien3006]

Hi everybody, 

I am still new to Power BI and i might have some basic questions.

So I have a dataset and I don't know how to build a nice design for the report. 

The data consists of 15 products. The value of 1 shows that the specific products are already in place, while those countries with 0 do not have the respective products. 

I want to have a chart showing the percentage of products, a chart shows data according to regions, and a table which show the data of region, country and each product (this table is easy). And all of those charts connect to each other. 

I have been trying and the result looks not so good. 

Here is the link to the dataset: https://drive.google.com/file/d/14u7YxWhZVUDFWruI_o24gf8iMnkQ4o3Z/view?usp=sharing 

Thanks so much!!!!!!!!!!!!!

[VijayP]

@kimlien3006 

Instead share your pbix so that We can give you some good suggestion

[kimlien3006]

hi @VijayP  I inserted a link to the dataset in my message. There are some Excel formulas, that's why I want to give you the data in Excel so that you can have better understanding of my data. The link is in the end of the message. 

Thanks so much!

[VijayP]

@kimlien3006 

You want like this??

[kimlien3006]

It looks really good to me ^^

[VijayP]

Ok Thanks ! Please share your Kudoes! 

I have added the Data to Power BI and created this!

[kimlien3006]

@VijayP  absolutely. Could you also please share with me shortly how you come up with this design?

[VijayP · Accepted solution]

@kimlien3006 

https://drive.google.com/file/d/1Knkn7OtNHejWJ1lllVDgQ9TN-cdrm4fI/view?usp=sharing

Down load from above link

Please Mark this as solution 

Thanks 

[kimlien3006]

@VijayP  thanks! I just have a question. Which Power BI version do you have? because I have version Jan 2020 and I could not open the file you sent

[VijayP]

@kimlien3006  I am using Power BI August 2020 Version

[kimlien3006]

HI @VijayP  sorry to bother you again! Could you please send me the file again because it seems to be another file from another topic. I opened it and it was another report. Many many thanks!

[VijayP]

@kimlien3006 

https://drive.google.com/file/d/1rpnCBli4uDMNIquvdQHHmG-61mKRn1ph/view?usp=sharing

Find the link