Forum Discussion
One Date filter for all tables
Hi Folks,
Need help on this,
Table Details:-
1. There are total 05 tables Divison(Divison coding), Master(all consumer date), BillInfo(bill generated data), Paid Cons(paid consumer details) & payment Details.
2. There are many other significant columns in these tables, but to trim data in size we removed the columns.
What we did in this sheet:-
1. First we applied a date filter of Month Year from master table on each card, Than each & every card also having their respective date filer.
2.Apart from Month Year filter from master table on each card, none of the date filter applied on any another card.(check edit interaction from format)
3. This is our actual result.
What we want:-
We need to create a tabular report where these 04 columns & few other columns to be created.As of now,, we are achieving the actual/desired reult by applying date filter in each card value. But on report we cant show 04 date filter. I want to create one single date filter which filters all the table accordingly.
Filters from Master table must be applied rest of the the tables.
You can get the file from here,
Thanks.
4 Replies
- danextian
Super User
Hi Anonymous ,
The file seems to be inaccessible outside your orgnization.
- amitchandak
Please create a date table and join it with dates in all transactions/fact tables and then you can use that for filtering date. Create a column for month year, year, quarter etc in date table. If one table have more than one date you can use create join with all dates. One will be active and another one will be inactive.
Refer how to use userelation with multiple date in the same table : https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s.
Refer
https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions
https://www.archerpoint.com/blog/Posts/creating-date-table-power-bi
https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Connect on LinkedinHi Amit,
if I use USERELATIONSHIP, it wont allow to filter the data from master table fields(like Consumer status & phase)
