Forum Discussion
Dynamic table based on slicer
I have multiple tables, eg Sales table, Billing table, CN table, Receipt table where each of the table having a date field. Next, I have a date slicer. I want to allow user to select the date range a...
Hello siewwei ,
you shouldn't have the fact tables linked to each others. you need to have dimension tables that are common between all these fact linked to the fact.
thus the date table won't have a circular dependancy anymore.
check the concept of star schema https://learn.microsoft.com/en-us/power-bi/guidance/star-schema