use dax funxtion to hide columns ,only show the columns i select

[Anonymous]

Hello , 
    i create three field ,and i seperate the data column name into these three field ,and i also add two slicer for the table selecting ,if i select nothing ,it will show all the columns ,if i select in all the filter ,then it will show the column i select.
   now i want the table to be if i select nothing ,it will only show the column that will always show[column 1],if i select the columns in the filter , it will show the columns with [column 1]
    how can i do to achieve this ? really thankful if somebody can answer my question.

[Ritaf1983]

Hi @Anonymous 

Please provide a workable sample data and your expected result from that. It is hard to figure out what you want to achieve from the description alone.  

https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216

[Anonymous]

I create three field [AO],[Attribute],[Measure],column a are from [AO],column b are from [Attribute],column C from [Measure],each field multiple select is accepted , so there are maybe have situations like :

ag_cd	column a	column b	column b1	column c	column c1	column c2	....

if i select nothing , i want the table to only show like this

ag_cd

[v-zhengdxu-msft · Accepted solution]

Hi @Anonymous 

Please try this:

Here I create a set of sample:

Table:

Then add a Fields Parameter:

Let report readers use field parameters to change visuals (preview) - Power BI | Microsoft Learn

In the table view, add a calculated column in the Parameter table:

Column = MID('Parameter'[Parameter],1,8)

Finally, create a Slicer, the result is as follow:

Best Regards

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