I have a table called Revenue. It was generated from List.Numbers(Start, Count, Increment). The values are basically from 0 to 999.9 by 0.1. There is only one column called Series.
I have a table called Revenue. It was generated from List.Numbers(Start, Count, Increment). The values are basically from 0 to 999.9 by 0.1. There is only one column called Series.
I have an M Parameter bound to Series, call it Parameter_Revenue (Multi-select = No). The suggested values is "List of values" and Current Value is 3 in the Manage Parameters prompt.
I use this parameter in a SQL query.
let
Source = Sql.Database("Server_Name", "Database_Name", [Query="
SELECT [IND]
,[CAT]
,[INT]
FROM [Schema].[Table]
WHERE [IND] = "& Number.ToText(List.First({Parameter_Revenue})) &"
"])
in
Source
(Oversimplification of my needs/query.)
In Power BI, the column Series is in a Slicer visualization (old one, not "new") Style > Dropdown. If I select a value, say 1, Parameter_Revenue takes the value 1 and the SQL Query works as expected.
However, I need to present the Slicer as Style > "Greater than or equal to". So if I type 1 in the slicer, I want to take the min(Series) = 1 and pass that to the M Parameter. The reason I need this presentation is because I need a way for users to type an input.
I was able to bind the parameter to Series in the slicers as "Greater than or equal to", but it looks like that was an error/bug/not an intended feature.
Anyway, is there a way to pass the minimum from the slicer/table to the parameter for a SQL query?
If this cannot work, is there an alternative way to pass a value to my query? I cannot use the embedded Power App alternative because my IT admins will not provide permissions/licenses to our users once we publish the report to the app (premium capacity).
We prefer to avoid 3rd party apps/visualizations.
