Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello
I have a parameter setup that filters a number of quieries & charts I have setup.
Parameter Values are = "All,1,2,3,4,5,6,7,8,9,10,11"
Now the numerical values work fine but I also want to filter by 'All' the numbers also.
I'm thinking if I could have a nested query something like the following ,obviously the formatting would be different 🙂
let
Source = Sql.Database("server1", "APro"),
dbo_OEE_FOR_BI = Source{[Schema="dbo",Item="OEE_FOR_BI"]}[Data],
IF LineNumberPar = (1-11) then filter like the below
#"Filtered Rows" = Table.SelectRows(dbo_OEE_FOR_BI, each [LocId]=LineNumberPar)
Else
Include all the records from Item="OEE_FOR_BI
in
#"Filtered Rows"
Is that the right track?
Regards
Geoff
Solved! Go to Solution.
In your scenario, you want to do it in your Power query, right? Actually, this requirement can be done by using Slicer easily. We can turn on Select All option.
Besides, here is a blog about IF statement in Power query for you reference.
http://www.excelguru.ca/blog/2014/08/27/the-if-function-in-power-query/
Regards,
Charlie Liao
In your scenario, you want to do it in your Power query, right? Actually, this requirement can be done by using Slicer easily. We can turn on Select All option.
Besides, here is a blog about IF statement in Power query for you reference.
http://www.excelguru.ca/blog/2014/08/27/the-if-function-in-power-query/
Regards,
Charlie Liao
Right ok ,maybe I over think things
Cheers
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |