Dynamicaly select column and filter based on slicer value

[Shivayogi123]

Hi Team,

I have month slicer which has list of values from Jan to Dec.

I have column which has names and 12 different columns as below :

When i select month in slicer i need to apply filter on specific month solumn which ha "Y"

As an example if i select January in slicer

I need to filter the table as below for January column

Same for Feb and other months.

Unpivoting the month columns fixes the issue but i dnt want that as my row count is in crores.

Can i filter on the existing table or can i create a new table (Summarised table like that) which has only the selected month filtered with Y on that selected month.

I have tried the below to get the selected month:

Sel_month = SELECTEDVALUE(Sheet1[Date]).

I am trying something like :

If(Sel_month = "January",CALCULATETABLE(Sheet1,Filter(Sheet[Jan] = "Y")),

If(Sel_month = "February",CALCULATETABLE(Sheet1,Filter(Sheet[Feb] = "Y")),

Atached is the pbix i tried and please let me share your thoughs on the same.

https://1drv.ms/u/s!AjqH7k_M5ZVEgzZZOALAn5ZSV18a?e=XT6ehm 

[amitchandak]

@Shivayogi123 , Calculatetable will not take the slicer value.

I think field parameters can help

https://amitchandak.medium.com/field-parameters-conditional-formatting-517aacc23fdf