cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jader3rd Regular Visitor
Regular Visitor

Report level filters getting removed for referenced data sources

I have a data source with a Date column. I set that Date column as a Report level filter. I now reference the data source in a new data source; do some transformations to other columns, but leave Date alone. Charts that use the new data source show values from dates outside of the Report level filter. Why?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
jader3rd Regular Visitor
Regular Visitor

Re: Report level filters getting removed for referenced data sources

One thing I learned from this experience is that adding calculated columns to the original table is probably a better way to go, than creating referenced tables, and treating them as a View over the original data. That does solve one of the charts I had, but not the other.

What ended up solving my problem for all cases, was to create a calculated table which did Distinct(DateColumn) on the primary table, and then creating one to many relationships with the other tables. Then set the report level filter to the dates calculated table.

That does make me wonder though, if you create a new table, which references another table as its source, if that doubles the data stored.

View solution in original post

3 REPLIES 3
Community Support Team
Community Support Team

Re: Report level filters getting removed for referenced data sources

Hi jader3rd,

 

The word "I now reference the data source in a new data source" as you said above is referred to click Get data button again to get data of the former data source in the same pbix? If yes, the report filter applies to all pages in the report of original data source, can't apply to the other data source. So, recommend you add the same column of the second data source to the report level filter to meet your demand.

 

You can learn more: https://docs.microsoft.com/en-us/power-bi/power-bi-reports-filters-and-highlighting

 

Best Regards,

Amy

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

jader3rd Regular Visitor
Regular Visitor

Re: Report level filters getting removed for referenced data sources

No, that's not what I did. When looking at one table in Power BI, you can right click on it and select "Reference". That will create a new table where the query looks like Source = [Original Table].

Having three report level filters with the name of Date is really odd.

Highlighted
jader3rd Regular Visitor
Regular Visitor

Re: Report level filters getting removed for referenced data sources

One thing I learned from this experience is that adding calculated columns to the original table is probably a better way to go, than creating referenced tables, and treating them as a View over the original data. That does solve one of the charts I had, but not the other.

What ended up solving my problem for all cases, was to create a calculated table which did Distinct(DateColumn) on the primary table, and then creating one to many relationships with the other tables. Then set the report level filter to the dates calculated table.

That does make me wonder though, if you create a new table, which references another table as its source, if that doubles the data stored.

View solution in original post

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors