how to hide column in power bi table based on slicer selection

[Jane689]

Hi ,

I have a date filter with values say 08/21/2023, 08/22/2023, 08/23/2023 and so on . I have also created a power bi table which has different columns with same name as above i.e 08/21/2023, 08/22/2023, 08/23/2023.

I want if date slicer is set to 08/21/2023 then power BI table should show only column with label 08/21/2023 , rest all columns should be hidden. similarly if date slicer is set to 08/22/2023 then power BI table should show only column with label 08/22/2023 , rest all columns should be hidden.

basically if slicer value equals to table column name then only that specific column should be displayed rest all columns should hide.

[Haith70s]

Good day

Please find some options  

Options 1 

base the column on a measure. In the measure use "if" function. If the date slicer is equal to the desired date value/s then blank() else place the required value/calculations.

Option 2 

2.1 create a measure that checks if the value of the date slicer (use the "selectedvalue" function) is equal to the desired value/s.

2.2 Conditional format the background and font colour of the value field based on the measure (step 2.1). This makes the (column) value blend in (can not be seen) with the table/matrix background. 

I found this resource to be very helpful as well. 

https://perytus.com/2021/01/26/how-to-use-conditional-formatting-to-show-text-image-instead-of-blank...

[ray_aramburo]

The field parameter will go on the Columns of the Matrix and the Sum of values/Measure on the Values.

[Jane689]

am using table visual not matrix visual since i want to sort each column individually which is different dates in my case 

[ray_aramburo]

If you have your dates as columns I'd recommend you to unpivot that table or use field paramaters. 

[Jane689]

I want to keep the dates as columns only as this is my requirement

[ray_aramburo]

You can still display them as columns by placing the date value column in a pivot but if you don't want to transform the table schema, then field parameters is your only option. 

[Jane689]

field parameters is using nameof function by default , i want to display sum of each date column in the power bi table.