Filter multiple tables on single dateTime filter using powerbi

1
votes

I'm trying to filter with single common date filter multiple tables using powerbi. I'm using postgres RDS engine with powerbi. What i need is

  • Filter 4 tables with single dateTime filter.

PS. Each table has own date column

My schema looks like.

Table1

t_id| Date

Table2

t_id| Date

Table3

t_id| Date

Table4

t_id| Date

1
databasedataframepowerbi
Refer this :- stackoverflow.com/questions/53227345/… – Siddharth Thanga Mariappan

1 Answers

1
votes

You need to add a date dimension table, with relationships to the date fields in your tables. Then you can filter this common calendar table and the filter will be reapplied through these relationships.

You can create your own calendar table, or combine the dates from all 4 tables to get a list of all date values (merge queries), or use DAX function like CALENDAR or CALENDARAUTO to create such table. It is a good idea to mark it as date table.

Then add one to many relationships between this calendar table and date columns of your tables (calendar table on the one side).

Add a slicer with the date field from the calendar table, or report level filter on it, depending on your preferences, to filter on it.