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
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.

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

      Hi Elangamban,

      Based on my understanding, you want to display the fields highlighted in green line when you select "Bottom LIne", and the fields highlighted in red line when you select "Order Value", right? If it is, there must be relationship between Sales, Services, Products,Total Table and Date table. Filter is used to filter the rows, when you select one value in slicer, the corresponding rows in ralated table will be filtered. 

      Best Regards,
      Angelia

      • Elangamban's avatar
        Elangamban
        Regular Visitor
        9 years ago

        Hi,

         

        For testing purpose, I've created relationship between Sales table and date table.

         

        But, the data is not displaying when I chose the date table.

         

        It will be helpful if you explain what kind of relationship should to be create? (For testing purpose lets assume these two tables, sales and date table)

         

        Thanks...