Forum Discussion

sekinod's avatar
sekinod
Helper II
5 years ago
Solved

Filter value by two dates columns

  I want to filter the above data by two date columns which are "LPD" and "DATEOPEN". "DATEOPEN" columns values should be within the month and "LPD" should be month end date. According to that...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi sekinod,

    Current power bi slicers not able to be filter on multiple fields at the same time.

    For you scenairo, you can use date field that not linked to current table and write a measure with if statement to compare selection and current values and use on visual level filter to filter records.
    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi sekinod,

Current power bi slicers not able to be filter on multiple fields at the same time.

For you scenairo, you can use date field that not linked to current table and write a measure with if statement to compare selection and current values and use on visual level filter to filter records.
Regards,

Xiaoxin Sheng