cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Burnsy Frequent Visitor
Frequent Visitor

Table reflects suppliers with <6 invoices in last 12 months, other visuals do not reflect same

Hi,

I have set up a table to show all suppliers we have paid in the last 12 months who have submitted less than 6 invoices.  My problem is the other visuals I am using in this report (number of suppliers card, invoice value card, site useage pie etc), do not reflect the table visual level filter, rather they continue to reflect the full data set for the period nominated.

 

My source data is per invoice per supplier used for the last 5 years (so I have approx 295,000 lines) .  I have set up a slicer to enable selection of date range.  My table visual filter is set to show invoice count of "less than 6".  

 

I have tried numerous ways to rectify this with out success.  Any suggestions?

1 REPLY 1
Community Support Team
Community Support Team

Re: Table reflects suppliers with <6 invoices in last 12 months, other visuals do not reflect sam

Hi @Burnsy

Do you add some condition in the "Visual level filter" of the "Table" visual, but you want the other visuals on the same report page can be reflected by the condition, right?

If so, please note that "Visual level filter" can only reflect one visual", to let the condition reflect all visuals on the report page, please add the condition in "Page level filter".

Please read this article to see the difference among different level filters.

https://docs.microsoft.com/en-us/power-bi/power-bi-report-add-filter

https://www.wisdomaxis.com/technology/software/powerbi/interview-questions/how-many-types-of-filters...

 

Additionaly, if you add one column in a slicer visual, then the slicer doesn't work for all visuals on the same page using the same table, please see the "visual interaction" and change the settings.

For more details, please refer to this article.

https://docs.microsoft.com/en-us/power-bi/service-reports-visual-interactions

 

Best Reagrds

Maggie

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 98 members 1,359 guests
Please welcome our newest community members: