Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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

  • 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.

    • Anonymous's avatar
      Anonymous
      Not 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".