Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more

Reply
TerCh
Frequent Visitor

Two graphs from the same table, one including date filter and one excluding date filter.

‎03-28-2025 06:09 AM

I am strugeling to show 2 separate graphs from the same table. One graph with a date slicer (via the date table) and one graph that should show all categories excluding the date filter. Both graps should filter by category a visual table (same for both).

Example  table

Purchasing_DocumentDocument_DateOTDOverdue backlog
430000289321.11.2024On Time 
430000251514.06.2024Late >90 Days
430000251514.06.2024Late >90 Days
430000251514.06.2024On Time 
430000251514.06.2024Late >90 Days
430000251514.06.2024Late >90 Days
430000289321.11.2024On Time 
430000289321.11.2024On Time 
460005450911.02.2025Late >90 Days
460004219202.09.2024Late >90 Days
460004825814.11.2024Late >90 Days
460003780309.07.2024Late 30-90 Days
460004564215.10.2024Late >90 Days
460004882921.11.2024Late 30-90 Days
460005526519.02.2025Late >90 Days
460004564215.10.2024Late >30 Days
460004564215.10.2024Late >90 Days
460004649425.10.2024Late 30-90 Days
460004115018.08.2024Late >90 Days
460004564215.10.2024Late 30-90 Days
460001873427.11.2023Late >30 Days
460005450911.02.2025Late >90 Days
460005049916.12.2024Late 30-90 Days
460001623931.10.2023Late >90 Days
460005450911.02.2025Late >90 Days
460005526519.02.2025Late >90 Days
460004564215.10.2024Late >90 Days
460005526519.02.2025Late >90 Days
460005526519.02.2025Late >90 Days
460004975505.12.2024Late 30-90 Days
430000306719.03.2025On Time 
460004649425.10.2024Late >90 Days
460004564215.10.2024Late >90 Days
460004693830.10.2024Late >90 Days
460005450911.02.2025Late >30 Days
460005293122.01.2025On Time 
450091269131.10.2022Late >90 Days
460005049916.12.2024Late 30-90 Days
460005700813.03.2025On Time 
460004975305.12.2024Late 30-90 Days
460004975505.12.2024Late 30-90 Days
450092148301.05.2023Late >90 Days

 

Hope you have a solution for this as I have tried to make a separat table for the other graph, but the data filte still filtering both graphs.

Labels:
Message 1 of 4
206 Views
0
1 ACCEPTED SOLUTION
ToddChitt
Super User
Super User

‎03-28-2025 06:37 AM

If you the two visuals are from the SAME table, and that one table is related to a Date dimension, like I suspect it is, AND you have a date slicer on the page, THEN you should be able to manage this is "Edit Interactions" on the XX menu. First go to the Format menu and you will find "Edit interactions" as the first button on the left. Next click on the Date slicer, then for the table where you want to NOT be affected by that slicer, click the "None" icon that shows up in its upper right corner. That icon then switches from a hollow circle with a diagonal line through it to a filled circle to indicate the interaction relationship FROM the Date slicer. Lastly, turn off "Edit interactions".

Hope that helps.




Did I answer your question? If so, mark my post as a solution. Also consider helping someone else in the forums!

Proud to be a Super User!



View solution in original post

Message 3 of 4
180 Views
0
3 REPLIES 3
TerCh
Frequent Visitor

‎03-28-2025 07:07 AM

Thanks alot. That was a easy solution 🙂

Message 4 of 4
171 Views
0
ToddChitt
Super User
Super User

‎03-28-2025 06:37 AM

If you the two visuals are from the SAME table, and that one table is related to a Date dimension, like I suspect it is, AND you have a date slicer on the page, THEN you should be able to manage this is "Edit Interactions" on the XX menu. First go to the Format menu and you will find "Edit interactions" as the first button on the left. Next click on the Date slicer, then for the table where you want to NOT be affected by that slicer, click the "None" icon that shows up in its upper right corner. That icon then switches from a hollow circle with a diagonal line through it to a filled circle to indicate the interaction relationship FROM the Date slicer. Lastly, turn off "Edit interactions".

Hope that helps.




Did I answer your question? If so, mark my post as a solution. Also consider helping someone else in the forums!

Proud to be a Super User!



Message 3 of 4
181 Views
0
AilleryO
Memorable Member
Memorable Member

‎03-28-2025 06:31 AM

Hi,

If you disable the interaction between your 2 visuals, would it be enough ?

https://learn.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions?tabs=p...

Let us know

Message 2 of 4
186 Views
0

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

View All
Top Solution Authors
View All