Forum Discussion

ElliotP's avatar
ElliotP
Post Prodigy
9 years ago
Solved

Visual Level Filter a Measure

Evening,   I have a bar chart with the axis as a date and the value as a measure for the Sum of Net Sales in the past week.   When I add a visual level filter of a created conditional column (tex...
Need Help
Tips and Tricks
  • ElliotP's avatar
    ElliotP
    9 years ago

    It had to do with the filtering between the tables. The cross directional filter between my date table and data table was set to Both as opposed to single and this was causing issues with my filtering from values in my data table.

v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
9 years ago

Hi ElliotP,

Please create a measure and a card used to display the measure value using the following formula. Create a table, please add the weeknum as row level, CurrentWeekNum measure as value level, please see the if CurrentWeekNum measure is constant.

CurrentWeekNum=CALCULATE (
MAX ( 'ExtendedCalendar'[WeekNum] ) - 1, FILTER(ALL( 'ExtendedCalendar' ), 'ExtendedCalendar'[Year] = CurrentYear )
)


Or could you please share your .pbix file for further analysis?

Best Regards,
Angelia

 

 

ElliotP's avatar
ElliotP
Post Prodigy
9 years ago

Thank you, I sorted it out earlier today. It had to do the filtering of the relationships between tables (not sure how it got changed, but oh well).

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Microsoft Employee
    9 years ago

    Hi ElliotP，

    Do you have resolved your issue? If it does, please mark helpful reply or share your own solution, which will help more people.

    Best Regards,
    Angelia

    • ElliotP's avatar
      ElliotP
      Post Prodigy
      9 years ago

      It had to do with the filtering between the tables. The cross directional filter between my date table and data table was set to Both as opposed to single and this was causing issues with my filtering from values in my data table.