Combining records with same id to generate bar chart

[Anonymous]

Hi All,

I have two tables. Table-1 which stores property id & property name. Table-2 which stores details about document by referencing id (from table-1) as foreign key in table-2 (column prop_id).

Using this data I need to generate a bar chart which will show top 5 documents with likeCount. So, X axis will show name of the document and Y-axis will show the likeCount.

Please share your inputs or link to post where similar use case is already addressed on how I can achieve this use case. Thank you in advance for your inputs.

Table-1:

id	local_name
1	name
2	file_size
3	likeCount
4	country
5	city
6	pincode

Table-2:

id	prop_id	string_value	long_value
1	1	abc.docx	null
1	2	null	5
1	3	null	10
1	4	India	null
1	5	Bangalore	null
1	6	null	560099
2	1	test_abc.docx	null
2	2	null	3
2	3	null	15
2	4	India	null
2	5	Bangalore	null
2	6	null	560099

Thank you.

[Ashish_Mathur]

Hi,

Please show the exact expected result.

[Anonymous]

Below is the screenshot of Bar Graph which shows expected result..

[Ashish_Mathur · Accepted solution]

Hi,

You may download my PBI file from here.

Hope this helps.

[Anonymous]

Thank you Ashish, you solution helped me in resolving the issue.

[Ashish_Mathur]

You are welcome.