Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Dim_Date join with multiple fact date column

Hi All,   I have 3 tables    Dim_date (datetime) Fact1 (datetime) Facts 2(datetime)   RealtionShip Fact1 (datetime) 1:M Dim_date (datetime) Crossfilter direction (BOTH) and Active/ Fact2 (da...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    Not clear. But make sure that both table are joined on Date column with date table having no time. Also, all dates are cover in date dimension

v-kelly-msft's avatar
v-kelly-msft
Community Support
6 years ago

Hi Anonymous ，

 

You can use "userelationship" function when you make one of the relationship inactive.

 

Here is the reference.

 

Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
Anonymous's avatar
Anonymous
Not applicable
6 years ago

But i want to show Date table - Hour, Fact1 - Count(custid), fact2(salesamt) in same graph

  • v-kelly-msft's avatar
    v-kelly-msft
    Community Support
    6 years ago

    Hi Anonymous ，

     

    Can you show me your .pbix file if it's not confidential?You can upload it to onedrive then share the link  to me.

     

    Best Regards,
    Kelly
    Did I answer your question? Mark my post as a solution!
    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      v-kelly-msft  Thanks much in advance ,

       

      https://1drv.ms/u/s!ApPgrUdbr1NBbT4-UdfcQufC8Iw?e=SWehbd

       

      if i select any col and walkin from line.my sales,transaction should split based on hour,day so on

       

      as of now day is coming correct sales=140 and walkin=40 and transaction=52,but line should not be extended, hour wise how to do i dnt have nay ideal. please please help