Forum Discussion
How to use a slicer range without slider...
Hi,
I discovered that if I change my slider data from text to numeric the slider allowed me the option for equal to or less than so that solved my problem. So I added a custom column where I changed my data from text for fiscal month. Since the data is fiscal month in the format of 01, 02... 25 I had to use a DAX method to change the values in a new column to 1,2,3,4...25 so I could use the slider in the way I needed.
That worked.
Many thanks!
Community ChampionMeasure =
VAR __selected = SELECTEDVALUE('Table'[Value]) //slicer
RETURN
SUMX(FILTER('Another Table',[Data] <= __Selected),[Some Column])
Hard to be specific. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Hi,
I discovered that if I change my slider data from text to numeric the slider allowed me the option for equal to or less than so that solved my problem. So I added a custom column where I changed my data from text for fiscal month. Since the data is fiscal month in the format of 01, 02... 25 I had to use a DAX method to change the values in a new column to 1,2,3,4...25 so I could use the slider in the way I needed.
That worked.
Many thanks!