Dynamic hideable columns in a table visual

Question

Hi,&nbsp;I found this Post:https://community.powerbi.com/t5/Community-Blog/Dynamic-Hideable-Columns-in-Power-BI-Table-Visual/ba-p/662808&nbsp;it helped me out a lot with a report. But I have problem using this for multiple tables.There is no data in the columns when I try to do the same thing for a second table with other values.&nbsp;Is there a DAX-Expert here that can help me figure out what the problem is?&nbsp;Kind regardsNoah

allisonkennedy · Answer

noah44&nbsp; And are you creating additional tables like the ones in the tutorial or trying to use the same? If you want to have two unrelated filters for the columns, you'll need to do that with two tables, and then update the DAX to look at the value of both tables, does that help or make any sense?

allisonkennedy · Answer

noah44&nbsp;Can you please paste some sample data here and explain what you mean by second table - is that a second table visual or data model table or both?

noah44 · Answer

AllisonKennedy&nbsp; I am working with customer Data, so I can't post it sadly.&nbsp;I mean a second Table Visual with different values but from the same data model&nbsp;

allisonkennedy · Answer

We don't need the actual data, but need to know more about the data model - how many tables are you working with within the data model?

noah44 · Answer

The data used in the table visuals comes from one Table. Within the report I have three imported tables and the ones described in the tutorial. But I only use data from one of the imported ones.

Forum Discussion

Dynamic hideable columns in a table visual

7 Replies

Related content

Dynamic Column headers

Dynamic Column Name

Dynamic Variable in Calculated Columns

Dynamic column comparison of last column

Dynamic Column Header in Visualisation