cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Massig
Frequent Visitor

Merging two visualizations into one

I have 2 tables ... (data is coming from 2 data sets linked)

One where I have

CUSTOMER NAME / FIRST ACTIVITY / ACTIVITY TYPE / LAST ACTIVITY / ACTIVITY TYPE

 

and a second matrix visualization

CUSTOMER NAME / ACTIVITY TYPE 1 / ACTIVITY TYPE 2 etc ... and count of activity type as value.

 

I was trying to have a combined visualization that shows

 

CUSTOMER NAME FIRST ACTIVITY / ACTIVITY TYPE / LAST ACTIVITY / ACTIVITY TYPE and then the matrix part with the count of activity by type.

3 REPLIES 3
v-piga-msft Resident Rockstar
Resident Rockstar

Re: Merging two visualizations into one

Hi @Massig ,

It seems that you want to create one visual with the two data source.

If so, I think, you could create the relationshio between the two tables with CUSTOMER NAME column.

In addition, what is the count of activity by type? Which activity type do you want to count, table1 or table 2?

If it is convenient, you'd better share some data sample which could reproduce the scenario and your desired output so that we could help further on it.

Best  Regards,

Cherry

 

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Massig
Frequent Visitor

Re: Merging two visualizations into one

Hi

thanks for your help.

I have got 2 tables behind the visualizations which I linked by company.

What I can't get to work is the visualization...

SOme pics..

These are the linked table

Then there is the visualization 1 - which is company plus first / last activity done coming from Member status update date and subtype

And visualization 2 - which is company plus activity by Ctype

I don't seem to be able to make one visualization with 

Company + first activity + subtype + Last activity + Subtype + the matrix with all the campaign and the count of campaign by company - ie. literally joining the 2 into 1.

SO it kind of looks like this

 

Thanks!

 

 

 

 

 

v-piga-msft Resident Rockstar
Resident Rockstar

Re: Merging two visualizations into one

Hi @Massig ,

Will have error message if you drag the fields in the visual 1to the visual 2?

To be more helpful, please share the data sample which could rerproduce youer scenario so that I could have a test on it.

Best  Regards,

Cherry

 

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Join THE global Microsoft Power Platform event series.

Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors