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...
Hi,
There is an alternative way you can get your desired solution.
- Create a measure using "New measure" option and within that, you define your colour i.e. green for NVD and colour red for the marks below 6,0 etc.
- In conditional Formating select "Find Rule" option from the drop-down and In based on field drop down select the measure which you have created.
I have attached pbix file for your reference.
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.