Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Dynamic Filter with selection button or slider or calendar

Hi,   I have a Matrix where i need to implement a filter:   The user should be able to choose a year: 2013, 2014, 2015, 2016, 2017, 2018   The filter selects on the field QUARTER the 4th quarte...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Hi Anonymous,

     

    Unfortunately, power bi not support to create dynamic calculated column/table based on slicer/filter.

    If you mean let formula only calculate with specific date range, it is possible.

     

    Sample:

    Column formula =
IF (
    OR ( MONTH ( Table[DATE] ) = 12; Table[DATE] = TODAY () - 1 );
    'measure formula';
    BLANK ()
)

    Use your calculation formula to replace bold part, it only calculate on December and yesterday.

     

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Thanks Xiaoxin Sheng,

 

that is what I did (see my previous answer)

But I think I need a calculated column SELECT that calculates =OR(MONTH(DATE) = 12; DATE = TODAY() - 1)

In this way its easy to add the filter:  SELECT  = True

 

Do you know how to calculate this expression in a calculated column?

 

R.W.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi Anonymous,

 

Unfortunately, power bi not support to create dynamic calculated column/table based on slicer/filter.

If you mean let formula only calculate with specific date range, it is possible.

 

Sample:

Column formula =
IF (
    OR ( MONTH ( Table[DATE] ) = 12; Table[DATE] = TODAY () - 1 );
    'measure formula';
    BLANK ()
)

Use your calculation formula to replace bold part, it only calculate on December and yesterday.

 

Regards,

Xiaoxin Sheng