Forum Discussion
Filter columns within a table
Hello, I have been looking for a solution to the following problem for several days:
I am assembling a table within a dashboard bringing columns from different tables of my model, one of them is the description of the products, which is in a table in 3 different languages (There is a table in the model that has an id, and then 3 more columns, each with the description in a different language).
How can I make the table I put together in the dashboard show, according to the language filter, the corresponding column?
That is, you should change which column you are bringing to the table, depending on the filter.
I hope you understand and that you can help me, thank you!
2 Replies
Syndicate_Admin gastonflaiszman
I have attached a file (below signature) with a couple options for you. Depends if you need this to be a column or if measure is ok. For option B you need to ensure you're still using a value from the unpivoted dimension table in the visual as well in order to ensure the filters propogate properly, otherwise you'll need to create a custom measure to enable that to happen.
Thank you very much for both possible solutions, it is exactly what I needed.
Anyway, unfortunately I still could not make it work in the table that I am assembling, I understand that it is due to some problem of relationships between the tables where I am extracting the columns.
When loading the filter as a column, the table is loaded and never displayed, perhaps it is due to the number of records, although the base with which I am working is not that large.Would you have any suggestions on how to find out where exactly the problem comes from?
Thank you!!
