Conditional Formatting of Combobox Text Color?

[jetform_consult]

I already know how to do conditional formatting on values in a table/card, but is it possible do text color formatting IN A COMBOBOX, where (at the moment) I display NON-WORKING days with an astrix at the end of the date?

I'd like to remove the astrix and display non-working days with a RED Text Font instead.

[jetform_consult]

I forgot to mention that my company refuses to update beyond the January 2019 version of PBI.  I know the NEWer versions of PBI have more control over what you can do, but our version is somewhat limited.

[FBergamaschi]

Hi @jetform_consult

yes you can, here my result test

define a measure that results in a text

go to the cell options and select text color basedon a measure and use that measure

If this helped, please consider giving kudos and mark as a solution

@me in replies or I'll lose your thread

Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page

Consider voting this Power BI idea

Francesco Bergamaschi

MBA, M.Eng, M.Econ, Professor of BI

[danextian · Accepted solution]

Hi @jetform_consult 

When you say combobox, do you mean a dropdown slicer? It isn't currently possible to conditionally format the color of an item in a dropdown slicer. You'll have more flexibility with the new  slicers which allow conditional formatting for the value and background color and an option to use  a label instead of the column values as a callout. There's no dropdown equivalent though.

Please see the attached pbix.

[jetform_consult]

Yes...I forgot to mention that my company refuses to update beyond the January 2019 version of PBI which is somewhat limited in its capabilities.

[AntoineW]

You are cleaning your data with Power Query on Desktop ? 

You can filter out them by using Power Query.

You can have a specific column on your date table to know if it's a non-working day (boolean).

And add a dax measure with condition to conditional formatting on values

this resource could be helpful : https://www.youtube.com/watch?v=NdQjlblelT0