Forum Discussion
Conditional formatting on a table in Power BI DASHBOARD
Is there a way I can do conditional formatting of the values in Table 1 (price Index by month),based on the value in table 2 (Target Price Index). The price index in Table 1 is a measure that I have created and The Target Price Index is a calculated column
4 Replies
Please provide sample data that covers your issue or question completely.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523Is there a way I can do conditional formatting of the values in Table 1 (price Index by month),based on the value in table 2 (Target Price Index). The price index in Table 1 is a measure that I have created and The Target Price Index is a calculated column. Details after the screenshot. Currently the conditional format it is applying is a default setting from Power BI
Price Index is calculated based on the below formula which is based on annual sales and competitor Sales
Price Index = DIVIDE(sum('All detail'[Annual Sales $]),sum('All detail'[Competitor Annual Sales $]),0)*100Target index is a static value based on the category (details in screenshot)Please provide usable sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.The output should be like below
Category Price Index Target Index Comments CONFECTIONERY 120 110 Red for above target Foodservice 90 100 Green for below target Price Index is mesure calculated as follows
Price Index = DIVIDE(sum('All detail'[Annual Sales $]),sum('All detail'[Competitor Annual Sales $]),0)*100
Target Index is a calculated column
This is the source table
Competitor Article parent CategoryRole Squad Category ArticleCategory ArticleNumber ArticleDescription Annual Sales $ Competitor Annual Sales $ Target Index Mode 13310 Last Minute Impulse Snacking FROZEN TAKE HOME ICE CREAM 48350 CONNOISSEUR 1LT CARAMEL HONEY MAC 37296 39960 110 Mode 13310 Last Minute Impulse Snacking FROZEN TAKE HOME ICE CREAM 65809 CONNOISSEUR 1LT MONTANA MINT 13230 13693.05 110 Mode 13310 Last Minute Impulse Snacking FROZEN TAKE HOME ICE CREAM 48350 CONNOISSEUR 1LT CARAMEL HONEY MAC 37296 39587.04 110 Mode 13310 Last Minute Impulse Snacking FROZEN TAKE HOME ICE CREAM 65809 CONNOISSEUR 1LT MONTANA MINT 13230 14042.7 110 Mode 71642 Basket Builder Food for Later FOODSERVICE TAKE HOME READY MEAL 71642 FUEL'D CHIPOTLE FRIED CHICKEN 15958.08 15535.2 100 Mode 69848 Basket Builder Food for Later FOODSERVICE TAKE HOME READY MEAL 69848 YOUFOODZ SLOW-COOKED BBQ BEEF & MASH 4033.25 4401.583 100 Mode 71643 Basket Builder Food for Later FOODSERVICE TAKE HOME READY MEAL 71643 FUEL'D STEAK, CHIPS & GRAVY 8794.161 8812.559 100 Mode 70150 Basket Builder Food for Later FOODSERVICE TAKE HOME READY MEAL 70150 YOUFOODZ CREAMY CHICKEN CARBONARA 9504.1 10303.95 100 Mode 71642 Basket Builder Food for Later FOODSERVICE TAKE HOME READY MEAL 71642 FUEL'D CHIPOTLE FRIED CHICKEN 36940.25 31839.71 100 Mode 69848 Basket Builder Food for Later FOODSERVICE TAKE HOME READY MEAL 69848 YOUFOODZ SLOW-COOKED BBQ BEEF & MASH 14902.95 14018.3 100 Mode 72152 Basket Builder Food for Later FOODSERVICE TAKE HOME READY MEAL 72152 FUEL'D CHICKEN CARBONARA 47847.8 41241.2 100 Mode 71643 Basket Builder Food for Later FOODSERVICE TAKE HOME READY MEAL 71643 FUEL'D STEAK, CHIPS & GRAVY 16989.34 14643.53 100
