How can I create a single visualization from two source files to analyze relationship

[Kaijh]

Hello,

I am trying to create a line chart showing the relationship between how many users ran a bot in a given week and how many new users there were in the same week. 

I have 3 relationships to consider:

1. is a people file that has information about the user such as location, staff level, business group, etc. 

2. is a run detail file that tells me how many times a person has run the bot on a given day, columns include:

UserID, DateofActivity 

3. is a file that tells me when a user first downloaded the bot, columns are the same as the second file mentioned above

Currently I have estabished relationships with the 2nd and 3rd file to the first file based on userid so I can view my dashboard by staff level etc. 

My issue is that I want to count usernames by date for my first and second file and put in a visualization but this does not work because I haven't established a connection with the two (won't let me establish a relationship because of the already established relationship with the first file.)

Is there any way I can see the data points for the second and third file in the same visualiztion? I somehow need them to share the same date field.

Thanks!

Kai

[Kaijh]

Hello,

I am trying to create a line chart showing the relationship between how many users ran a bot in a given week and how many new users there were in the same week. 

I have 3 relationships to consider:

1. is a people file that has information about the user such as location, staff level, business group, etc. 

2. is a run detail file that tells me how many times a person has run the bot on a given day, columns include:

UserID, DateofActivity 

3. is a file that tells me when a user first downloaded the bot, columns are the same as the second file mentioned above

Currently I have estabished relationships with the 2nd and 3rd file to the first file based on userid so I can view my dashboard by staff level etc. 

My issue is that I want to count usernames by date for my first and second file and put in a visualization but this does not work because I haven't established a connection with the two (won't let me establish a relationship because of the already established relationship with the first file.)

Is there any way I can see the data points for the second and third file in the same visualiztion? I somehow need them to share the same date field.

Thanks!

Kai

[v-danhe-msft]

Hi @Kaijh ,

Could you please post some simple sample data and your desired result to have a test if possible?

You could see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Regards,

Daniel He