Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Reply
SC-THOLD-IT
Frequent Visitor

Filter Specific Data from different Timeperiod, without changing Timeperiod

Hello everyone,

 

  1. i have a summed revenue from the last 4 Calenderweeks displayed as a linegraph 
    SCTHOLDIT_1-1673533378818.pngSCTHOLDIT_0-1673534097934.png

     

    The Filtering in 4 last Calenderwek is done by "Filter-on-Visual level"

  2. and revenues by productcategories but only the last week as Columngraph 
    SCTHOLDIT_3-1673533501806.png

    The Filtering of last Calenderwek is also done by "Filter-on-Visual level"

  3. If i filter by a productcategory, it also filters the timeperiod of the linegraph of (last week - shown as a dot) instead of only filtering by the productcategory

Linegraph of only last weekLinegraph of only last week

 

i tried all() filters, and searched for a solution on several forums, but their solutions doesnt seem to fit to my problem

 

how can i keep the linegraphs "last 4 weeks" filter

1 ACCEPTED SOLUTION
SC-THOLD-IT
Frequent Visitor

i got the Solution on my own:

The problem was the Last Calenderweek "Filter-on-Visual Level" in "productcategory", i made a Measure with last Weeks Revenue explicitly for the productcategory visual and deleted the Filter-on-visual level.

If i crossfilter now by a certain productcategory, the linegraph gets only filtered by that productcategory

View solution in original post

2 REPLIES 2
SC-THOLD-IT
Frequent Visitor

i got the Solution on my own:

The problem was the Last Calenderweek "Filter-on-Visual Level" in "productcategory", i made a Measure with last Weeks Revenue explicitly for the productcategory visual and deleted the Filter-on-visual level.

If i crossfilter now by a certain productcategory, the linegraph gets only filtered by that productcategory

lbendlin
Super User
Super User

Change the interaction mode from crossfiltering to crosshighlighting,  or disconnect the tables and use measure filters instead.

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

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.