Forum Discussion
Solved
How to apply conditional colour formatting to Calculation Groups dynamically with Field Parameters?
How to apply conditional colour formatting to Calculation Groups dynamically with Field Parameters?
Please only reply if you know the answer.
Click here to see example PBIX
It has a Field ...
speedrampsPlease use the below measure in the matrix value section instead of field parameter.
Color Measure =VAR _selectedValue = SELECTEDVALUE('Calculation group'[Calculation item])RETURNSWITCH (TRUE(),_selectedValue IN {"PY", "TY","YoY","YoY%"} && MAX('Field parameter'[Parameter Name]) = "Units", [Units],_selectedValue IN {"PY", "TY","YoY","YoY%"} && MAX('Field parameter'[Parameter Name]) = "Value", [Value],_selectedValue IN {"PY", "TY","YoY","YoY%"} && MAX('Field parameter'[Parameter Name]) = "Packaging", [Packaging],_selectedValue IN {"PY", "TY","YoY","YoY%"} && MAX('Field parameter'[Parameter Name]) = "Products", [Products],BLANK() // Default case (no selection))
and then set the conditional formatting as the given picture by right clicking on the color measure. And you are done..Hope this help!!
If this post solved your problem, please mark it as a solution!!
Refer the images
1) navigate through image
2) Now after clicking on fx . You will see this pop up which says 1) type of condition 2) on which you want to apply and 3 ) here is the condition in which the values which is applied on 2) point which you selected it says that the value > = in % and < 0 in number will have Red colour.
Here is the link Calculating group colour
Please accept it as Solution if it helped you.
Thanks