Forum Discussion
Conditional formatting on dynamic formatting options
Hi WouterBo
Do you want to use conditional formatting in Funnel visual? "Show all" function is to show all lengeds and let you select colors manually. If you want to show differents colors by date, you can try to build a color measure and add this measure into fx in default color.
My Sample:
Color Measure:
Measure =
SWITCH(MAX('Table'[Date]),DATE(2021,10,30),"Blue",DATE(2021,12,04),"Yellow","Green")Click fx , Format by Field value and use Measure.
Result is as blow.
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.
Thanks Rico,
"I would like to know if ... it is possible to apply conditional formatting to dynamic formatting options."
I'm making a custom visual. Funnel is only an example to show what I mean.
Add dynamic options based on values.
Add conditional formatting to dynamically generated formatting options.
Can it be done?
Hi WouterBo
Conditional formatting is now supported in API 3.5 and above
It seem that Power BI supports you to add conditional formatting in default color currently.
Blog:
Support for conditional formatting for custom visuals
I think you can try to build a measure as I show above and add it into fx in default color to change the color of fields in your custom visual. It can be more complex and dynamic.
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.
