Forum Discussion

Krystian514W's avatar
Krystian514W
Frequent Visitor
1 year ago
Solved

Relationship bypass problem

Hello!   I have a problem with showing a certain thing in the report, I will describe it with a maximally simplified example. What I have: first table with dates and names, second table for calen...
Need Help
  • dk_dk's avatar
    dk_dk
    1 year ago

    Hi Krystian514W 

    Create a new measure:

    FilterCond =

    VAR weekn = WEEKNUM(CALCULATE(MAX(TBL[Date]),REMOVEFILTERS('Calendar')))

    VAR nextweek = MIN('Calendar'[Week])+1

    RETURN
    IF(weekn==nextweek,1,0)


    and add a visual level filter to the next week visual, and set FilterCond = 1.
     
    See my example:

     

     

     

     

     

    Unfortunately it stops working if I FilterCond is not explicitly part of the visual, but you can work around that by formatting the color of it to match the background, so it is invisible.

    Hope this helps! Let me know if you have any questions.

     

dk_dk's avatar
dk_dk
Super User
1 year ago

Hi Krystian514W 

Create a new measure:

FilterCond =

VAR weekn = WEEKNUM(CALCULATE(MAX(TBL[Date]),REMOVEFILTERS('Calendar')))

VAR nextweek = MIN('Calendar'[Week])+1

RETURN
IF(weekn==nextweek,1,0)


and add a visual level filter to the next week visual, and set FilterCond = 1.
 
See my example:

 

 

 

 

 

Unfortunately it stops working if I FilterCond is not explicitly part of the visual, but you can work around that by formatting the color of it to match the background, so it is invisible.

Hope this helps! Let me know if you have any questions.