Conditional Formatting - Power BI

0 votes
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..
May 9, 2019 in Power BI by priya
1,052 views

1 answer to this question.

0 votes

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.

answered May 9, 2019 by anonymous
• 33,030 points

Related Questions In Power BI

0 votes
1 answer
0 votes
0 answers
0 votes
1 answer
0 votes
1 answer

Why is the "Visual" tab missing in the formatting pane for a custom visual in Power BI?

The custom visual loses the "Visual" tab ...READ MORE

answered Jan 8 in Power BI by pooja
• 14,220 points
61 views
+3 votes
2 answers

Combine tables in Power BI

You can also achieve this using a ...READ MORE

answered Oct 5, 2018 in Power BI by lina
• 8,220 points

edited Oct 11, 2018 by Kalgi 2,614 views
0 votes
1 answer

Power Bi Dax Table

You need to wrap the numbers in ...READ MORE

answered Oct 5, 2018 in Power BI by Kalgi
• 52,350 points
1,239 views
0 votes
2 answers

Power BI Dax Multiple IF AND Statements

HI I have Column Patient 12 13 14 15 18 IN Patient=12, 13 Out ...READ MORE

answered May 23, 2019 in Power BI by VNK
19,103 views
0 votes
1 answer

Distinct count filtered by condition using Power BI Dax

Try this, it should work: DistinctCountActiveMonths = CALCULATE( ...READ MORE

answered Oct 5, 2018 in Power BI by Kalgi
• 52,350 points
37,823 views
0 votes
1 answer

Conditional formatting - Power BI

Hi Chandan, First, create a bar chart as ...READ MORE

answered Jun 13, 2019 in Power BI by anonymous
• 33,030 points
755 views
0 votes
1 answer

How to Install Power BI in Windows

Hi, Anitha Go to this Link https://powerbi.microsoft.com/en-us/downloads/ Then click on ...READ MORE

answered Feb 28, 2019 in Power BI by Cherukuri
• 33,030 points
1,209 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP