Forum Discussion

Elangamban's avatar
Elangamban
Regular Visitor
9 years ago

create a common date filter

Hi,   I need to create a common date filter for my tables. I've connect Dynamics crm to power bi.   Let's say I've three different team and for each of them has a table (sales, marketting, servic...
Need Help
tringuyenminh92's avatar
tringuyenminh92
Memorable Member
9 years ago

Hi Elangamban,

 

Yes, you need choose Manage Relationship -> New to create relationship or auto dectect to have cross filter between dates table and your fact table 

 

v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
9 years ago

Hi Elangamban,

After you create relationship between table, you'd better set the slicer to contral several reports, or several slicer contal one report. You can click one silcer->Formua->Edit Interactions to create the connection with other slicers and any visualization in the window. For example, the relationship will be created if you select the funnel-shaped highlighted in red. Oppositely, there is no connection between slicer and visual if the highlighted circle in yellow is light. When you select the one slicer and connect it with other report, please see the following screenshot.



If you have any other question, please feel free to ask.

Best Regards,
Angelia

  • Elangamban's avatar
    Elangamban
    Regular Visitor
    9 years ago

    Hi Angelia,

     

    Thanks for the reply, I'll try out that.

     

    Anyhow, the following image is what I want to acheive.

     

    Also I want to use the date in calendar table as Page level filter.

     

     

    I hope this picture explains my requirements.

    • v-huizhn-msft's avatar
      v-huizhn-msft
      Microsoft Employee
      9 years ago

      Hi Elangamban,

      Got it, the Sales, Services, Products and Total Report are in sample page or different pages?

      Best Regards,
      Angelia

      • Elangamban's avatar
        Elangamban
        Regular Visitor
        9 years ago

        Hi,

         

        I've tried the date slicer filter, but its not displaying any data, no error, only the table headers.

         

        Sales, Services, Products and Total Report will be in the same page.

         

        Thanks.