Forum Discussion
Conditional Formatting of Combobox Text Color?
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.
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.
5 Replies
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
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.
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.
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
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.
