Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
transactiondate is from my Data table, the other columns are all from my Date Table. Week Rank only works when paired with the other columns from the other table, there is a many to one relationship between transactiondate and Date.
Additonal notes for current structure of my date table...
Solved! Go to Solution.
Hi @Spudder112
When you use dimension tables (in this case the date columns) you must always use the dimension table on your visualizations, in this case when you use your calculation with the data from your fact table you are always getting the same result because of the filter path between the transaction table and the date table.
On the one to many you have a filter that is coming from the date table to the transactions table, the other way around is not possible so it's like there is no relationship between the table and you get always the same result.
Not sure what you are trying to achieve with this visualization but you must use the Date from the date table and not the transcation date.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @Spudder112
When you use dimension tables (in this case the date columns) you must always use the dimension table on your visualizations, in this case when you use your calculation with the data from your fact table you are always getting the same result because of the filter path between the transaction table and the date table.
On the one to many you have a filter that is coming from the date table to the transactions table, the other way around is not possible so it's like there is no relationship between the table and you get always the same result.
Not sure what you are trying to achieve with this visualization but you must use the Date from the date table and not the transcation date.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsUser | Count |
---|---|
123 | |
69 | |
67 | |
58 | |
52 |
User | Count |
---|---|
183 | |
90 | |
67 | |
62 | |
53 |