Forum Discussion

PaulDenne's avatar
PaulDenne
Icon for Helper I rankHelper I
2 years ago
Solved

table filter

Hi I am new to Power bi I have a table filtering weekly hours for all staff from daily timesheets into weeks using a date table to get week numbers and sum the hours for the week, and currently hig...
  • lbendlin's avatar
    lbendlin
    2 years ago

    Use a "What-if"  numeric parameter for that.

PaulDenne's avatar
PaulDenne
Icon for Helper I rankHelper I
2 years ago

thanks for that, I think i am so close but when I create the work limit table and the measuer then add slicer I dont get the single value option under slicer settings ?

 

thanks for help so far really appreciated

  • PaulDenne's avatar
    PaulDenne
    Icon for Helper I rankHelper I
    2 years ago

    think I see the issue my work table didnt generate the 30-60 range

    • lbendlin's avatar
      lbendlin
      Icon for Super User rankSuper User
      2 years ago

      Use a "What-if"  numeric parameter for that.

      • PaulDenne's avatar
        PaulDenne
        Icon for Helper I rankHelper I
        2 years ago

        many thanks, didn't cover that in my 1 day tutorial