Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
In an Excel spreadsheet, columns exist for
Date of birth
Age
Column Age stores the persons age and contains a formula with Conditional Formatting
If Age value >17.75 highlight in colour Red.
In powerbi, the data source is the spreadsheet.
Date of birth column is formatted as Date Short
Age column is formatted as Decimal number, 2 decimal places.
The report has a table that displays columns Date of birth and Age.
I select the Age field to apply Conditional formatting on Background.
If create a Rule, it only displays value between AND value
eg if value >= 'value' AND <'value'
I have selected the different drop downs options however it does not allow the rule based on 1 value. It always 'forces' 2 values between and I cannot get further.
If the field is Text format. The Rules display only 1 value to test.
However if the field is a number format, The rules display 2 values range that must be entered.
All I want is a simple condition if Age value >17.75 highlight in colour Red.
How can this be done.
Solved! Go to Solution.
Thank you @v-yaningy-msft
Now resolved, I used the following condition to get it working ..
If value => 17.5 number and <=100 number then Red
The condition is,
if Age is greater than or equal to 17.5 and less than or equal to 100 (years age), then Red.
Hi, @dd88
You can refer to @HarishKM reply. IF it does not work, you can try following method.
Method 1 :
Change the portion of the box to 100 Percent.
Method 2:
Use Measure
Measure:
Age2Color = IF(SELECTEDVALUE('Table'[Age2])>=17.75,"Red")
Effect:
Best Regards,
Yang
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
Thank you @v-yaningy-msft
Now resolved, I used the following condition to get it working ..
If value => 17.5 number and <=100 number then Red
The condition is,
if Age is greater than or equal to 17.5 and less than or equal to 100 (years age), then Red.
@dd88 Hello
You need to use Varriance of age to get the conditional formating.
Thanks
Harish Mishra
If I solve this issue Kindly give kudos and accept this solution.
User | Count |
---|---|
86 | |
82 | |
68 | |
67 | |
55 |
User | Count |
---|---|
123 | |
100 | |
90 | |
83 | |
66 |