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
65 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
• 32,420 points

Related Questions In Power BI

+1 vote
1 answer

Unable to install connector for Power Bi and PostgreSQL

I think the problem is not at ...READ MORE

answered Aug 21, 2018 in Power BI by nirvana
• 3,060 points
855 views
+2 votes
2 answers

Migrate power bi collection to power bi embedded

I agree with Kalgi, this method is ...READ MORE

answered Oct 11, 2018 in Power BI by Hannah
• 17,380 points
176 views
+1 vote
1 answer

Connect power bi desktop to dataset and create custom reports

Yes using Power BI REST API to ...READ MORE

answered Sep 18, 2018 in Power BI by Kalgi
• 50,050 points
164 views
0 votes
1 answer

Programmatically sign in - power bi

Basically: POST request to: https://login.microsoftonline.com/common/oauth2/token Body, form-url-encoded: grant_type: "password" scope: "openid" resource: "https://analysis.windows.net/powerbi/api" client_id: ...READ MORE

answered Sep 19, 2018 in Power BI by Kalgi
• 50,050 points
141 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,180 points

edited Oct 11, 2018 by Kalgi 275 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
• 50,050 points
136 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 22, 2019 in Power BI by VNK
10,445 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
• 50,050 points
10,934 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
• 32,420 points
50 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
• 32,420 points
60 views