topic Re: Custom Conditional Formatting based on user selection. in Developer

Custom Conditional Formatting based on user selection.

Anonymous — Sat, 04 Feb 2023 13:43:37 GMT

Hello Everyone,

I am working on a dashboard which requires to change conditional formatting based on user input.

For eg.

There is a target and conditional formatting is done on it based on

Minimum value to 90% down arrow

90% to 100% horizontal arrow

Above 100% up arrow.

Now the user wants that the conditional formatting of target should change based on his selection for eg.

If the user wants to change target % from

Minimum to 80% then arrow should change like

Minimum to 80% down arrow,

80% to 100% horizontal arrow

Above 100% up arrow.

Please help..

Re: Custom Conditional Formatting based on user selection.

Anonymous — Mon, 06 Feb 2023 08:19:05 GMT

Hi Anonymous ,

Firstly, I suggest you to create a percentage slicer by What if Parameter. Then use between option for that slicer. Here I suggest you to use whole number in what if parameter as below. If you use increment 0.01 and range from 1 to 1.2, Power BI will return incorrect result.

Measure:

Measure = VAR _RangeStart = MIN(Parameter[Parameter])/100 VAR _RangeEnd = MAX(Parameter[Parameter])/100 VAR _Percentage =CALCULATE(SUM('Table'[Value])) RETURN IF(_Percentage <=_RangeStart,-1,IF(_Percentage>_RangeEnd,1,0))

Finally, you can use conditional formatting in cell elements and set as below.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Custom Conditional Formatting based on user selection.

Anonymous — Mon, 06 Feb 2023 10:45:51 GMT

Thank You so much.. Anonymous it worked for me, just by modifying your logic i am able to get the desired result.