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.
I am wanting to use the icons conditional formatting option on a column which is based off another column I have created
The issue is that the new column is returning a scientific number. Even if I change the data type to Decimal and have 2 decimal places, or whole numbers the conditional formatting isnt working as expected.
The issue is with row 3 in the example and my confitional formatting is as per the below
The new column is Column B - Column A
The column I'm basing the conditional formatting off is from a DAX measure and the other cells that it is calculated off is from a DAX table
Any ideas?
Solved! Go to Solution.
Hi @jyouens
You may try rounding the numbers visibly in the measure for conditional formatting. For example,
Rule Measure = ROUND ( SUM ( 'Table'[Column B] ), 0 ) - ROUND ( SUM ( 'Table'[Column A] ), 0 )
You can also choose to use ROUNDDOWN or ROUNDUP per your need.
Hope this would be helpful.
Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!
Hi @lbendlin - thanks for the pointer
Please see the data below, taken from Excel files that I've loaded into power bi. I cannot share the pbix file due to sensitive info
Table - Test_Placement_Actualisation
ADVERTISER_CODE | MONTH_OF_SERVICE | ACTUALIZED_COST |
TEST | 2024/01 | 148212.4 |
TEST | 2024/01 | 2964.25 |
TEST | 2024/01 | 1026.38 |
TEST | 2024/01 | 72067.21 |
TEST | 2024/01 | 1441.34 |
TEST | 2024/01 | 6824.4 |
TEST | 2024/01 | 137356.09 |
TEST | 2024/01 | 2747.12 |
TEST | 2024/01 | 1445.78 |
TEST1 | 2024/01 | 25407.68 |
TEST1 | 2024/01 | 0 |
Table - Tracker_Recons
Client Code | Date | client_cost |
TEST | 01/01/2024 | 151176.65 |
TEST | 01/01/2024 | 73508.55 |
TEST | 01/01/2024 | 140103.21 |
TEST1 | 01/01/2024 | 25407.68 |
TEST | 01/01/2024 | 0 |
TEST | 01/01/2024 | 1026.38 |
TEST | 01/01/2024 | 6824.4 |
TEST | 01/01/2024 | 1445.78 |
TEST1 | 01/01/2024 | 1661.73 |
Hope this helps?
Hi @jyouens
You may try rounding the numbers visibly in the measure for conditional formatting. For example,
Rule Measure = ROUND ( SUM ( 'Table'[Column B] ), 0 ) - ROUND ( SUM ( 'Table'[Column A] ), 0 )
You can also choose to use ROUNDDOWN or ROUNDUP per your need.
Hope this would be helpful.
Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information or anything not related to the issue or question.
If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...
User | Count |
---|---|
86 | |
82 | |
68 | |
65 | |
55 |
User | Count |
---|---|
123 | |
100 | |
90 | |
83 | |
66 |