Conditional Formatting - Power BI

Question

My dataset consists of the project done by students i each department. I want to format the only few students below marks (constant) using a slicer and show only those students who crossed marks..

Answer 1

Hi Priya,

Create a parameter and add it as a slicer to take values for marks.

Create a measure.

Cut-off = IF(MARKS < [const],"#ff0000","#ffffff")

Now Add all students and marks on the sheet, go to conditional formatting, select background color and select field value as format and click ok.

Hope it helps.