Forum Discussion
table filter
Use a "What-if" numeric parameter for that.
Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
If you are unsure how to do that please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
If you want to get answers faster please refer to https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
Hi Ibendlin
did you get my reply and sample data, only noticed its not swing on the topic thread?
No. Please try again.
so I have data below in a table
NAME: hours worked
WK1 wk 2 wk 3
xxx 50 65 50
want to filter a table to show rows where any column in it is over 55 for hours worked
Name Current week Sum of Regular Hours ttrob Grxyyxthd 42 48.81 ttrob Grxyyxthd 44 56.83 ttrob Grxyyxthd 42 20.2 tbzxrthwtb Htddtb 43 12.00 tbzxrthwtb Htddtb 44 3.00 tztw Gutdt 42 23.37 tztw Gutdt 43 36.08 tztw Gutdt 44 46.46 tztw Ptrtrxzgt 42 36.62 tztw Ptrtrxzgt 43 34.45 tztw Ptrtrxzgt 44 48.98 tztlt Pxtwtb 42 47.91 tztlt Pxtwtb 43 50.87 tztlt Pxtwtb 44 47.88 tztlt Pxtwtb 43 11.02 tzrxtb Woollty 42 46.24 tzrxtb Woollty 43 48.80 tzrxtb Woollty 44 47.69 tltb Htywtb 42 23.51 tltb Htywtb 43 24.10 tltb Htywtb 43 11.75 tltb Htywtb 44 24.2 tltb Jtyytry 42 20.12 tltb Jtyytry 44 20.40 tltb Wxlkxbd 42 20.02 tltb Wxlkxbd 43 20.50 tltb Wxlkxbd 44 20.25 tltx Kbxght 42 32.55 tltx Kbxght 43 31.15 tltx Kbxght 44 41.77 twtbzt tttob 42 36.00 twtlxt Cltrkt 42 22.00 twtlxt Cltrkt 43 23.02 twtlxt Cltrkt 44 44.20 twjtz tlx 42 40.50 twjtz tlx 43 37.17 twjtz tlx 44 11.83 twy wttchtw 42 12.35 twy wttchtw 43 48.35 tbzrt Browb 42 27.83 tbzrt Browb 43 19.07 tbzrt Browb 44 2.12 tbzrtw Grxwtd 42 52.35 tbzrtw Grxwtd 43 51.22 tbzrtw Grxwtd 44 36.85 tbzrtw Wtlburtob 44 22.63 tbzrtw Wtltob 42 12.00 tbzrtw Wtltob 44 12.50 tbzy dwxth 42 22.05 tbzy dwxth 43 35.05 tbzy dwxth 44 11.03 tbgtlt Ltwrtbct 42 39.86 tbgtlt Ltwrtbct 43 23.31 tbgtlt Ltwrtbct 44 24.42 tbgtlt dttvtbtob 42 47.68 tbgtlt dttvtbtob 42 11.25 tbgtlt dttvtbtob 43 43.39