How to show dynamic values based on user selection in column

[sunil222]

How to show dynamic values based on user selection in column.

have a slicer i.e on Month shows values like   Jan 23 , feb 23 ..... so on

i created a calculated column to show the current month i.e Jan 24.

now user selects the slicer value Nov 23 , that is the current month to show Nov 23  values in the column and also column header changes to nov 23 this is purely based on user selection.

please help me on this very critical for me

current month dax logic used = 

Current Month Actual =

var a = EOMONTH(TODAY(),-2)+1

var b = EOMONTH(TODAY(),-1)

return

CALCULATE(SUM(SalesTeamPerformance[Actual]),KEEPFILTERS(DATESBETWEEN('Date'[Date],a,b)))

[Anonymous · Accepted solution]

HI @sunil222,

Current power bi does not support to create dynamic column/table based on filter effect. They are not host on the same level and you can't use the child level to affect its parent. I'd like to suggest creating measure expression to instead.

Notice: the data level of power bi(from parent to child level)

Database(external) -> query table(query, custom function, query parameters) -> data model table(table, calculate column/table) -> data view with virtual tables(measure, visual, filter, slicer)

Regards,

Xiaoxin Sheng