Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Help filtering time range by time stamp

Hello!   I am using an excel workbook as my source data here. Within the workbook there are individuel sheets for seperate bits of equipment with a number of variables recorded at minutel time stam...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous,

    It sounds like you want to achieve a custom filter effect from your slicer. For your requirement, you need to use the unconnected table as source of the slicer, then you can write a measure expression to extract the current value and compare it with table records to filter records and apply it on 'visual level filter' to filter records.

    Using the SELECTEDVALUE function in DAX - SQLBI

    Applying a measure filter in Power BI - SQLBI

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Anonymous,

It sounds like you want to achieve a custom filter effect from your slicer. For your requirement, you need to use the unconnected table as source of the slicer, then you can write a measure expression to extract the current value and compare it with table records to filter records and apply it on 'visual level filter' to filter records.

Using the SELECTEDVALUE function in DAX - SQLBI

Applying a measure filter in Power BI - SQLBI

Regards,

Xiaoxin Sheng