Forum Discussion
Slicer threshold based on raw column value
Hi,
Is it possible to create a threshold slicer based on a raw column value?
I have a column with values [10,20,30,40,50,60]. I want to create a slicer such that the value selected capture everything greater than or equal to it, i.e. if I select "10", then all data points with a column value >10 are visualized; if I select "50", only data points with a column value of 50 or 60 are visualized.
Is this possible, without having to create a parameter and reset it each time?
If the only was is to create a parameter, is it possible to change this parameter once I publish this report and create a dashboard?
swong,
Firstly, create a calculated table using the DAX below.
ValueTables = VALUES(Table[Column1])
Secondly, create a measure in your original table.
expectedresult = CALCULATE(SUM(Table[Column1]),FILTER(Table,Table[Column1] >= FIRSTNONBLANK(ValueTables[Column1],1)))
Thirdly, create a slicer using the column of the newly created table.
Regards,
Lydia
6 Replies
swong,
Firstly, create a calculated table using the DAX below.
ValueTables = VALUES(Table[Column1])
Secondly, create a measure in your original table.
expectedresult = CALCULATE(SUM(Table[Column1]),FILTER(Table,Table[Column1] >= FIRSTNONBLANK(ValueTables[Column1],1)))
Thirdly, create a slicer using the column of the newly created table.
Regards,
Lydia
