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
71 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,440 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
923 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
• 18,030 points
196 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
• 51,830 points
191 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
• 51,830 points
171 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,200 points

edited Oct 11, 2018 by Kalgi 327 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
• 51,830 points
158 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
11,314 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
• 51,830 points
12,660 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,440 points
59 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,440 points
68 views