Forum Discussion
Slicing by calculated column header
Hi josh_sheffield,
>>What I am trying to achieve is a slicer to turn the upper and lower limit lines on/off.
You can create a if parameter table as source of slicer to control limit lines measure display or hide.
Below is sample.
Table:
Variable = GENERATESERIES(0, 1, 1)
Measures
Selected = SELECTEDVALUE(Variable[Parameter])
maxline = IF ( [Selected] = 1, MAX ( 'Table'[Amount] ), 0 ) minline = IF ( [Selected] = 1, AVERAGE ( 'Table'[Amount] ), 0 )Regards,
Xiaoxin Sheng
Thanks for your reply. Sorry but I'm not sure on how I should implement this:
Anonymouswrote:
After these steps, you can write a measure to get selected item from slicer, then you can use measure result as parameter to calculate with other conditions.
I have the following data, where RH Upper and RH Lower are calculated columns:
I use this data to create the following plot:
What I am trying to achieve is a slicer to turn the upper and lower limit lines on/off.
I've created a table to store the column headers "RH Upper" and "RH Lower" but not sure where to go from there.
Kind Regards,
Josh
Hi josh_sheffield,
>>What I am trying to achieve is a slicer to turn the upper and lower limit lines on/off.
You can create a if parameter table as source of slicer to control limit lines measure display or hide.
Below is sample.
Table:
Variable = GENERATESERIES(0, 1, 1)
Measures
Selected = SELECTEDVALUE(Variable[Parameter])
maxline = IF ( [Selected] = 1, MAX ( 'Table'[Amount] ), 0 ) minline = IF ( [Selected] = 1, AVERAGE ( 'Table'[Amount] ), 0 )
Regards,
Xiaoxin Sheng