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

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Dina,

thankyou so much for taking the time and providing me a way forward. It really had be baffled on on to try to do this.

Ill try the setup and let you know how I go.

thanks again

 

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Dina,

 

finally got back to this tonight and I see how you have approached the problem. However I was after the actual rows to be filtered in the table not the count as expressed in your solution. Everything else Ive set up ( and have made a few mods ) but am struggling to get over the last hurdle with the returning the rows selected in those time periods.

 

  • 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