Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Merge results from two visuals

Hi, I have a PBI report that has two Table visuals that I need to merge together. They each have diferent filtering. I want to move the count1 for Bradley from visual A into visual B. I have included an example of the visuals below. 

Visual A                                         

   

Visual B          

 

Thanks, Mark

 

 

 

 

 

Need Help

2 Replies

  • Daniel29195's avatar
    Daniel29195
    Community Champion
    2 years ago

    Anonymous  Hello , 

    from my understanding , you want to show values from table 1 and table 2 into one table visual .. 

    one way i can think of to achieve what you want, it to create a new table containing all the values you need to show . 

    you can use union for this. 

     

    and then you can work with DAX to calculate the intended measure base on the filter context . 

    you can use. 

    NB :  the complexity of the work will depend on the complexity of the model . 

     

     

    let me know if this helps. 

    Best regards, 
    Daniel 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Can I union the two visuals or do I need to create a separate table in the Data Pane from the one already being used to populating the two visuals?

    Second question - Is there a table created behind each visual that can be referenced and manipulated?