Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

How to generate multiple tables depending on another visualization ?

Hello everyone ! 

I'm having an issue to resolve this : 

I have a visualization (a bubble map). I want to be able when selecting a value (a bubble) in this visualization to generate multiple tables (one table for each componant of the selected bubble).

 

The tables must be generated and shown on the report only if the selected bubble have at least on element. If multiple values are in the bubble, multiple and independent tables must be shown

 

I saw that we can show or hide visuals depending on a selected value, but I don't think that it will help me with this issue.

 

Thanks  for your answers

 

  • Hi Anonymous ,

     

    Sorry for that, but based on my research, we can only control the data to show or hide in multi table visual by using following measure in visual filter,but we did not find an effective way to generate tables in the report view dynamically. 

     

     

    CanShow = IF(SELECTEDVALUE('Table'[Column1])in FILTERS('Table'[Column1]),1,BLANK())

     

     

     


    Best regards,

2 Replies

  • v-lid-msft's avatar
    v-lid-msft
    Community Support

    Hi Anonymous ,

     

    Sorry for that, but based on my research, we can only control the data to show or hide in multi table visual by using following measure in visual filter,but we did not find an effective way to generate tables in the report view dynamically. 

     

     

    CanShow = IF(SELECTEDVALUE('Table'[Column1])in FILTERS('Table'[Column1]),1,BLANK())

     

     

     


    Best regards,

    • Anonymous's avatar
      Anonymous
      Not applicable

      Thank you for your answer