Forum Discussion
smart filtering in multisource report
I am building a Power BI report from multiple sources, that have diferent intervals of updates. Every update I place a new dump file in Sharepoint so I can compare the data and see old dashboards by filtering the report date.
The data looks like this:
What I want is some sort of smart filter:
select nothing: show maximum date (1-2-21 for risks, 1-1-21 for planning)
select feb-21 from date table: show 1-2-21 for risks, 1-1-21 for planning
select jan-21 from date table: (show 1-1-21 for both risks and planning
Do I need to enter this in every measure, (and if so: how?) Or is there some smart way of using the page-filter function?
You might be able to use LASTNONBLANK(), LASTDATE(), or MAX() if all you want is to get the latest data from each feed based on your (disconnected) dates selection.
2 Replies
- lbendlin
Super User
You might be able to use LASTNONBLANK(), LASTDATE(), or MAX() if all you want is to get the latest data from each feed based on your (disconnected) dates selection.
- AnonymousNot applicable
Yes, that kind of worked for me!
it has some drawbacks, at the meta-data is not filtered by this date.
What did work was adding the date per visual as a filter and then set "Top 1 latest date".