Forum Discussion
conditional colouring by selection
Hi community, I have the following requirements: - Period (numeric, not as date) as filter selection - periods greater than selected period should be blue coloured - periods less than selected ...
Hi inf1948,
To achieve what you described you must follow these steps:
- Create a separate table that will have the period dictionary and use it in the slider.
- Create a measure that will dynamically check whether the selected period is larger or smaller.
Measure = VAR _period = SELECTEDVALUE('Period'[Period]) VAR _tableperiod = SELECTEDVALUE('Table'[Period]) RETURN IF(_period > _tableperiod,0,1)_period - dictionary, tableperiod - table with data
- Use this measure in Conditional formatting.
The result (I used background color, but you can also use this for font color):
_______________
If I helped, please accept the solution and give kudos! 😀
Hi inf1948,
To achieve what you described you must follow these steps:
- Create a separate table that will have the period dictionary and use it in the slider.
- Create a measure that will dynamically check whether the selected period is larger or smaller.
Measure =
VAR _period = SELECTEDVALUE('Period'[Period])
VAR _tableperiod = SELECTEDVALUE('Table'[Period])
RETURN IF(_period > _tableperiod,0,1)_period - dictionary, tableperiod - table with data
- Use this measure in Conditional formatting.
The result (I used background color, but you can also use this for font color):
_______________
If I helped, please accept the solution and give kudos! 😀
awesome, thank you!