Forum Discussion

vineetdubey's avatar
vineetdubey
Regular Visitor
8 years ago

Date Range + ID - Drill Through Filter withe Real Time Data

Hi have two tables MasterTable and DetailTable Created a Report (Page1 + Page1)

with the Drillthrough filter on MasterID column. but how can i achieve or filter the data based on the 

( MasterID + Date Range filter )  with most recent data. Can i pass these parameters in SQL Sps anyways.

 

How can i achive this. Please Suggestion / Help / Support is highly required, 

 

Thanks 

Vineet

2 Replies

  • vineetdubey's avatar
    vineetdubey
    Regular Visitor
    8 years ago

    Hi All 

    I have two tables Master and Detail. (Report (Page1+Page2) ) 

    I have setup a drill through filter on ReceiptID its working fine. But How do i pass the range of Dates (StartDate and EndDate ) along with ReceiptID filter on the detail table. Also i needed realtime data on the Detail Page but not sure how to achieve this in Power BI. Any Idea or Suggestions are greatly appricialted. 

     

    Thanks Vineet

     

  • v-piga-msft's avatar
    v-piga-msft
    Resident Rockstar
    8 years ago

    Hi vineetdubey.

     

    If I understand your requirement correctly that you want to filter the data in DetailTable by MasterID + Date Range ?

     

    Could you provide more details? What about your Data Range, in Master Table or Details Table?

     

    If it is convenient, could you share some data sample which could reproduce your scenario and your expected output, so that we can help further investigate on it?

     

    Best Regards,

    Cherry