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

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