Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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 (datetime) 1:M Dim_date (datetime) Crossfilter direction (BOTH) and realtionship Active , result i get in pic 1 if i make relationship inactive then i get the result in pic 2
How to resolve this please help
Solved! Go to Solution.
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
Hi @Anonymous ,
You can use "userelationship" function when you make one of the relationship inactive.
Here is the reference.
But i want to show Date table - Hour, Fact1 - Count(custid), fact2(salesamt) in same graph
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.
@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
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
understood now. created calendar and hour table and joined the timestamp with facts
if i dnt join on datetime, how can i extract hourly data
Best practices want the Dim_Date to be a list of distinct days with no gaps, with no time.
In this way you will be able to use it as a calendar table for your model and to use all the Time Intelligence functions.
In your fact you should calculate the date and link it the Dim_Date with a 1:M relationship that goes from Dim_Date to Fact.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
114 | |
95 | |
86 | |
78 | |
66 |
User | Count |
---|---|
153 | |
125 | |
114 | |
111 | |
95 |