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 

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

    so last step ..hopefully

    I replaced names with my tables and when I add the show filter not data comes for any value, so I have messed up somewhere addin the measuer?

    Show =
    var a = SUMMARIZE('Detailed - Timesheet Report',[Name])
    var b = ADDCOLUMNS(a,"mx",max('Detailed - Timesheet Report'[Regular Hours]))
    return if(maxx(b,[mx])>=SELECTEDVALUE('Work Limit'[Work Limit]),1,0)