Creating a User Selection table

[Dora]

Hi,

I want to make a user selection table as follows:-

When I create this I only get one Column Selected table I need to Select multiple columns in single table,I done this using following

Measure Selection =
SWITCH(TRUE(),
VALUES('Column'[Column]) = "Total Sales", [Total Sales] ,
VALUES('Column'[Column]) = "Total Cost", [Total Cost],
VALUES('Column'[Column])= "Total Profit", [Total Profits],
BLANK())

How to make this from DAX,since switch can only choose one selection and tables get only one value per column.

Please Help !!!!

Thank You 

Best Regards,

Dora

[Anonymous]

HI @Dora,

Can you please explain more about your requirement?

AFAIK, one measure is impossible to return multiple values at same time.(switch function also not works for summary records)

If you mean display dynamic multiple columns based on slicer and switch function, it is impossible to achieve.

Regards,

Xiaoxin Sheng

[Dora]

Hi @Xiaoxin Sheng

I need to make a table which columns can be selected by user .User can select multiple columns according to requirment.

Then How can I make a table which columns can be chosen according to customer selection.

Thank You,

Best Regards,

Dora

[Anonymous]

HI @Dora,

Current you can't use filter or slicer to create dynamic column/table:

Calculated Column/Table Change Dynamically According to Slicer Selection in the Report.

Regards,

Xiaoxin Sheng

[Dora]

Hi @AnonymousXiaoxin Sheng.

Do you know any method of making dynamically changing column, table.

Thanks,  

Best Regards,

Dora

[Anonymous]

Does anypne have a solution to this?  I need to create a table based on user selection.  Example, underlying table/view contains 10 columns, but user would like to see only 4 of them. ProductID, ProductDecs, ProductWeight, ProductColor and not display the other 6 columns.