Dynamically showing columns in a table visual

[Sam1]

Hi

I have a dataset with 10 columns, I need to show few columns from that in a table visual but depending on the data. So lets say if the dataset has col1 = ‘One’, I only show col2,col3,col4 and if not show col3,col4,col5.
Since the dashboard is same I want to select which columns can be shown depending on the data in the underlying dataset

[sagmukhe]

@Sam1 - Thank you for posting your query. I believe this can be done using parameters and calculated fields. Please go through the following posts, where a similar technique has been discussed which can provide you with the required relevant idea to try out the implementation at your end. Hope this helps!

Dynamically change if a field is a row vs column in a pivot table

Hello, Is there a way to dynamically change whether a field is in the rows or columns field well with an on-screen control? Example: [image] User starts with the row/column setup above but maybe decides they want fields 2 and 3 in the columns field well to now be setup like below. [image] I realize this can easily be done by an author in an analysis but is there a way for a reader to make this change with some on-screen control in the dashboard?

Dynamic selection of columns in table

Hi, I have a table with lots of columns. So, I want to give privilege to user to select columns of their choice using any kind of multiselect dropdown list or filter. Is there any feature which could be of my use to create dynamic table?