Forum Discussion

Ken_Berg's avatar
Ken_Berg
Regular Visitor
1 year ago

Show full table in visual dynamicly based on filter

Hi Guys. 

Hopefully you can help me out.

I have a table with 2 rows containing 1 column called [Tablenames]. The values are  'Customer'and 'Vendor'. 
I have 2 more tables containing the actual data themselves: tables [Customer] and [Vendor]. 

Is it possible to use 1 visual, that shows the full [Customer]table when filter [TableNames] contains 'Customer' or the full [Vendor]table when filter [TableNames] contains 'Vendor' 

This example has 2 tables in total. I am having 50 tables in my report. i would like to create a drilltrough that brings the tablename to the next page and there shows the full table defined in the filter. 

Thanks! 

6 Replies

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    1 year ago
    I am having 50 tables in my report

    Combine them all into a single table. Include an identifier column "Type"  that holds the distinction Customer/Vendor/etc.  Use that column for filtering.

    • Ken_Berg's avatar
      Ken_Berg
      Regular Visitor
      1 year ago

      The column headers are different, for each of the 50 tables. 

      • Anonymous's avatar
        Anonymous
        Not applicable
        1 year ago

        Hi Ken_Berg , hello lbendlin, thank you for your prompt reply!

        Power BI does not inherently support dynamically switching entire data tables based on slicer.

        Each visual requires a predefined data source, and it does not allow for dynamically changing the data source or table based on a condition.

         

        This means you cannot directly switch between displaying the [Customer] table or the [Vendor] table based on the selected [TableNames] value. 

        Best regards,

        Joyce

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