Forum Discussion
Solved
Conditional formatting, numbers including text
I tried to apply conditional formatting to analyze marks (numbers and text combined, see picture below). In Microsoft Excel it is possible to analyze those combined data (example color green for NVD...
I couldn't download the pbix file because I have no Google account, can you send it to me by e-mail or drobox. I found the "New measure" option but I do not know which algorithm to type. Measure = Format colour green if "NVD" and Format colour red if marks < 6,0. I hope you can place the algorithm in the discussion. I also found the https://docs.microsoft.com/nl-nl/power-bi/desktop-tutorial-create-measures, some examples in Dutch but the formula explanation of Conditional formatting is not sufficient.
