Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Anonymous
Not applicable

Combining records with same id to generate bar chart

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:

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

 

Table-2:

idprop_idstring_valuelong_value
11abc.docxnull
12null5
13null10
14Indianull
15Bangalorenull
16null560099
21test_abc.docxnull
22null3
23null15
24Indianull
25Bangalorenull
26null560099

 

Thank you.

1 ACCEPTED SOLUTION

Hi,

You may download my PBI file from here.

Hope this helps.

Untitled.png


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

5 REPLIES 5
Ashish_Mathur
Super User
Super User

Hi,

Please show the exact expected result.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
Anonymous
Not applicable

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

2019-10-22_1958.png

 

 

Hi,

You may download my PBI file from here.

Hope this helps.

Untitled.png


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
Anonymous
Not applicable

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

You are welcome.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Helpful resources

Announcements
March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.