Visual interactions

[Fiona83]

Hi there 

I am working on a dashboard to show allocated and capacity.

To do this I had to merge both data sets and add a "source" column indicating if it was demand or Capacity by each date

Visual one - shows the total allocated by date. (filtered by the "source" column)

Visual two - shows the capacity and allocated by person

I want to be able to select a Month on visual one and then visual two to show both allocated and demand.

Currently, when I do this visual 2 (understandably) shows only the allocated aligning with the first visual: 

Is there a way around this while keeping the visual one the same?

Thanks

Now with a link to sample https://drive.google.com/file/d/1WCf6YP8mE2BlSndGF92hrnZGQquKg6-1/view?usp=sharing

[v-xiaotang]

Hi @Fiona83 

Thanks for reaching out to us.

need a .pbix sample file to check if it is possible to show both capacity and demand when you select a Month on visual one. thanks.

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[Fiona83]

@v-xiaotang  thank you.

I have created a sample pbix here along with the data: 

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