Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Hour Relative Filter

Hi Everyone ,   hoping someone might have an idea on how to do this as its currently got me stumped in PBI. Have an incrementing data set of values of which includes a datetime value. Interested ...
Tips and Tricks
  • v-diye-msft's avatar
    v-diye-msft
    7 years ago

    Hi Anonymous 

     

    I’m not calculating the counts of columns, the total volume could be removed in format pane. I’m filtering the actual table by rows, not sure where confused you. Kindly share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.

    I attached the pbix here for your reference: https://wicren-my.sharepoint.com/:u:/g/personal/dinaye_wicren_onmicrosoft_com/EaTca9zvCA9EsnLH6ksyJDwBZi3I9-YNDrtfsR_RHns5mA?e=9ubbIv 

     

    Best regards,

    Dina Ye

  • v-diye-msft's avatar
    v-diye-msft
    7 years ago

    Hi Anonymous 

     

    If my above post helps, could you please consider Accept it as the solution to help the other members find it more quickly. thanks!

     

    Best regards,

    Dina Ye

v-diye-msft's avatar
v-diye-msft
Community Support
7 years ago

Hi Anonymous 

 

I’m not calculating the counts of columns, the total volume could be removed in format pane. I’m filtering the actual table by rows, not sure where confused you. Kindly share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.

I attached the pbix here for your reference: https://wicren-my.sharepoint.com/:u:/g/personal/dinaye_wicren_onmicrosoft_com/EaTca9zvCA9EsnLH6ksyJDwBZi3I9-YNDrtfsR_RHns5mA?e=9ubbIv 

 

Best regards,

Dina Ye

v-diye-msft's avatar
v-diye-msft
Community Support
7 years ago

Hi Anonymous 

 

If my above post helps, could you please consider Accept it as the solution to help the other members find it more quickly. thanks!

 

Best regards,

Dina Ye