topic Re: Dynamic Fill Color based on Multiple AND Conditions in Developer https://community.fabric.microsoft.com/t5/Developer/Dynamic-Fill-Color-based-on-Multiple-AND-Conditions/m-p/4341255#M58796 <P>What's a shape visual ?</P> Tue, 24 Dec 2024 01:08:46 GMT lbendlin 2024-12-24T01:08:46Z Dynamic Fill Color based on Multiple AND Conditions https://community.fabric.microsoft.com/t5/Developer/Dynamic-Fill-Color-based-on-Multiple-AND-Conditions/m-p/4340853#M58790 <P>Hi I have a table like below.</P><P>&nbsp;</P><P>I have a shape visual for each stage. I want to fill up color dynamically in the shape visual based on certain conditions. Moreover, i have only one slicer in the report which is "FixVersion Name".</P><P>Conditions:</P><P>Stage="Stage Name" &amp;&amp; [Is Final Round]="True" &amp;&amp; [Stage Status]="Success" then "Green",</P><P>Stage="Stage Name" &amp;&amp; [Is Final Round]="True" &amp;&amp; [Stage Status]="UnSuccess" then "Red",</P><P>Stage="Stage Name" &amp;&amp; [Is Final Round]="True" &amp;&amp; [Stage Status]="In Progress" then "Yellow"</P><P>&nbsp;</P><P>like this</P><P>Do i need to change the structure of the table? if it need to work properly ( Pls suggest a table structure but need to hall all info )</P><P>or Any workaround that would be greatful.</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>FixVersion ID</TD><TD>FixVersion Name</TD><TD>Stage</TD><TD>Round</TD><TD>Is Final Round</TD><TD>Planned Date</TD><TD>Actual Date</TD><TD>Stage Status</TD><TD>Tracking of Stage</TD></TR><TR><TD>8</TD><TD>SFP.R.11.8</TD><TD>Release Initiation</TD><TD>Round 1</TD><TD>TRUE</TD><TD>12/13/2024</TD><TD>12/14/2024</TD><TD>Completed</TD><TD>On Track</TD></TR><TR><TD>8</TD><TD>SFP.R.11.8</TD><TD>QA2 Deploy</TD><TD>Round 1</TD><TD>FALSE</TD><TD>12/13/2024</TD><TD>12/13/2024</TD><TD>Completed</TD><TD>On track</TD></TR><TR><TD>8</TD><TD>SFP.R.11.8</TD><TD>QA2 Deploy</TD><TD>Round 2</TD><TD>FALSE</TD><TD>12/14/2024</TD><TD>12/15/2024</TD><TD>Failed</TD><TD>Off track</TD></TR><TR><TD>8</TD><TD>SFP.R.11.8</TD><TD>QA2 Deploy</TD><TD>Round 3</TD><TD>FALSE</TD><TD>12/15/2024</TD><TD>12/15/2024</TD><TD>Completed</TD><TD>On Track</TD></TR><TR><TD>8</TD><TD>SFP.R.11.8</TD><TD>QA2 Deploy</TD><TD>Round 4</TD><TD>TRUE</TD><TD>12/16/2024</TD><TD>12/16/2024</TD><TD>Success</TD><TD>On Track</TD></TR><TR><TD>8</TD><TD>SFP.R.11.8</TD><TD>QA2 Testing &amp; Sign-Off</TD><TD>Round 1</TD><TD>TRUE</TD><TD>12/15/2024</TD><TD>12/16/2024</TD><TD>Success</TD><TD>On Track</TD></TR><TR><TD>8</TD><TD>SFP.R.11.8</TD><TD>Stage Deploy</TD><TD>Round 1</TD><TD>FALSE</TD><TD>12/18/2024</TD><TD>12/18/2024</TD><TD>Unsuccess</TD><TD>On Track</TD></TR><TR><TD>8</TD><TD>SFP.R.11.8</TD><TD>Stage Testing &amp; Sign-Off</TD><TD>Round 1</TD><TD>FALSE</TD><TD>12/19/2024</TD><TD>12/19/2024</TD><TD>In Progress</TD><TD>On Track</TD></TR><TR><TD>8</TD><TD>SFP.R.11.8</TD><TD>Perf Deploy</TD><TD>Round 1</TD><TD>FALSE</TD><TD>12/18/2024</TD><TD>12/19/2024</TD><TD>Not Started</TD><TD>On Track</TD></TR><TR><TD>8</TD><TD>SFP.R.11.8</TD><TD>Perf Testing &amp; Sign-Off</TD><TD>Round 1</TD><TD>FALSE</TD><TD>12/22/2024</TD><TD>12/25/2024</TD><TD>Blocked</TD><TD>On Track</TD></TR><TR><TD>8</TD><TD>SFP.R.11.8</TD><TD>Security Scans</TD><TD>Round 1</TD><TD>FALSE</TD><TD>12/23/2024</TD><TD>12/26/2024</TD><TD>Cancelled</TD><TD>On Track</TD></TR><TR><TD>8</TD><TD>SFP.R.11.8</TD><TD>Go/No-Go Decision</TD><TD>Round 1</TD><TD>FALSE</TD><TD>12/24/2024</TD><TD>12/27/2024</TD><TD>Cancelled</TD><TD>On Track</TD></TR><TR><TD>8</TD><TD>SFP.R.11.8</TD><TD>Prod Deploy</TD><TD>Round 1</TD><TD>FALSE</TD><TD>12/25/2024</TD><TD>12/25/2024</TD><TD>Cancelled</TD><TD>On Track</TD></TR><TR><TD>8</TD><TD>SFP.R.11.8</TD><TD>Prod Health Check</TD><TD>Round 1</TD><TD>FALSE</TD><TD>12/25/2024</TD><TD>12/25/2024</TD><TD>Cancelled</TD><TD>On Track</TD></TR><TR><TD>9</TD><TD>SFP.R.11.9</TD><TD>Release Initiation</TD><TD>Round 1</TD><TD>TRUE</TD><TD>12/13/2024</TD><TD>12/14/2024</TD><TD>Cancelled</TD><TD>On Track</TD></TR><TR><TD>9</TD><TD>SFP.R.11.9</TD><TD>QA2 Deploy</TD><TD>Round 1</TD><TD>FALSE</TD><TD>12/13/2024</TD><TD>12/13/2024</TD><TD>Completed</TD><TD>On track</TD></TR><TR><TD>9</TD><TD>SFP.R.11.9</TD><TD>QA2 Deploy</TD><TD>Round 2</TD><TD>FALSE</TD><TD>12/14/2024</TD><TD>12/14/2024</TD><TD>Completed</TD><TD>On track</TD></TR><TR><TD>9</TD><TD>SFP.R.11.9</TD><TD>QA2 Deploy</TD><TD>Round 3</TD><TD>FALSE</TD><TD>12/15/2024</TD><TD>12/15/2024</TD><TD>Failed</TD><TD>On Track</TD></TR><TR><TD>9</TD><TD>SFP.R.11.9</TD><TD>QA2 Deploy</TD><TD>Round 4</TD><TD>TRUE</TD><TD>12/16/2024</TD><TD>12/16/2024</TD><TD>Completed</TD><TD>On Track</TD></TR><TR><TD>9</TD><TD>SFP.R.11.9</TD><TD>QA2 Testing</TD><TD>Round 1</TD><TD>TRUE</TD><TD>12/13/2024</TD><TD>12/14/2024</TD><TD>Success</TD><TD>On Track</TD></TR><TR><TD>9</TD><TD>SFP.R.11.9</TD><TD>QA2 Testing</TD><TD>Round 2</TD><TD>TRUE</TD><TD>12/14/2024</TD><TD>12/14/2024</TD><TD>Success</TD><TD>On Track</TD></TR><TR><TD>9</TD><TD>SFP.R.11.9</TD><TD>QA2 Testing</TD><TD>Round 3</TD><TD>TRUE</TD><TD>12/15/2024</TD><TD>12/15/2024</TD><TD>Unsuccess</TD><TD>On Track</TD></TR><TR><TD>9</TD><TD>SFP.R.11.9</TD><TD>QA2 Testing &amp; Sign-Off</TD><TD>Round 4</TD><TD>TRUE</TD><TD>12/15/2024</TD><TD>12/16/2024</TD><TD>Not Started</TD><TD>On Track</TD></TR><TR><TD>9</TD><TD>SFP.R.11.9</TD><TD>Stage Deploy</TD><TD>Round 1</TD><TD>FALSE</TD><TD>12/18/2024</TD><TD>12/18/2024</TD><TD>Not Started</TD><TD>On Track</TD></TR><TR><TD>9</TD><TD>SFP.R.11.9</TD><TD>Stage Testing</TD><TD>Round 1</TD><TD>FALSE</TD><TD>12/18/2024</TD><TD>12/18/2024</TD><TD>Blocked</TD><TD>On Track</TD></TR><TR><TD>9</TD><TD>SFP.R.11.9</TD><TD>Stage Testing &amp; Sign-Off</TD><TD>Round 1</TD><TD>FALSE</TD><TD>12/19/2024</TD><TD>12/19/2024</TD><TD>In Progress</TD><TD>On Track</TD></TR><TR><TD>9</TD><TD>SFP.R.11.9</TD><TD>Perf Deploy</TD><TD>Round 1</TD><TD>FALSE</TD><TD>12/18/2024</TD><TD>12/19/2024</TD><TD>Cancelled</TD><TD>On Track</TD></TR><TR><TD>9</TD><TD>SFP.R.11.9</TD><TD>Perf Testing</TD><TD>Round 1</TD><TD>FALSE</TD><TD>12/19/2024</TD><TD>12/20/2024</TD><TD>Cancelled</TD><TD>On Track</TD></TR><TR><TD>9</TD><TD>SFP.R.11.9</TD><TD>Perf Testing &amp; Sign-Off</TD><TD>Round 1</TD><TD>FALSE</TD><TD>12/22/2024</TD><TD>12/25/2024</TD><TD>Cancelled</TD><TD>On Track</TD></TR><TR><TD>9</TD><TD>SFP.R.11.9</TD><TD>Security Scans</TD><TD>Round 1</TD><TD>FALSE</TD><TD>12/23/2024</TD><TD>12/26/2024</TD><TD>Cancelled</TD><TD>On Track</TD></TR><TR><TD>9</TD><TD>SFP.R.11.9</TD><TD>Go/No-Go Decision</TD><TD>Round 1</TD><TD>FALSE</TD><TD>12/24/2024</TD><TD>12/27/2024</TD><TD>Cancelled</TD><TD>On Track</TD></TR><TR><TD>9</TD><TD>SFP.R.11.9</TD><TD>Prod Deploy</TD><TD>Round 1</TD><TD>FALSE</TD><TD>12/25/2024</TD><TD>12/25/2024</TD><TD>Cancelled</TD><TD>On Track</TD></TR><TR><TD>9</TD><TD>SFP.R.11.9</TD><TD>Prod Health Check</TD><TD>Round 1</TD><TD>FALSE</TD><TD>12/25/2024</TD><TD>12/25/2024</TD><TD>Cancelled</TD><TD>On Track</TD></TR></TBODY></TABLE> Mon, 23 Dec 2024 13:18:58 GMT https://community.fabric.microsoft.com/t5/Developer/Dynamic-Fill-Color-based-on-Multiple-AND-Conditions/m-p/4340853#M58790 KR300 2024-12-23T13:18:58Z Re: Dynamic Fill Color based on Multiple AND Conditions https://community.fabric.microsoft.com/t5/Developer/Dynamic-Fill-Color-based-on-Multiple-AND-Conditions/m-p/4341255#M58796 <P>What's a shape visual ?</P> Tue, 24 Dec 2024 01:08:46 GMT https://community.fabric.microsoft.com/t5/Developer/Dynamic-Fill-Color-based-on-Multiple-AND-Conditions/m-p/4341255#M58796 lbendlin 2024-12-24T01:08:46Z Re: Dynamic Fill Color based on Multiple AND Conditions https://community.fabric.microsoft.com/t5/Developer/Dynamic-Fill-Color-based-on-Multiple-AND-Conditions/m-p/4342739#M58806 <P style="margin: 0in; font-family: Arial; font-size: 12.0pt; color: black;">Thanks for the reply from lbendlin&nbsp;, please allow me to provide another insight:</P> <P style="margin: 0in; font-family: Arial; font-size: 12.0pt; color: black;"><SPAN>Hi,&nbsp;<a href="https://community.fabric.microsoft.com/t5/user/viewprofilepage/user-id/396793">@KR300</a>&nbsp;<BR /></SPAN><SPAN>Thanks for reaching out to the Microsoft fabric community forum.</SPAN></P> <P style="margin: 0in; font-family: Arial; font-size: 12.0pt; color: black;">Regarding the issue you raised, my solution is as follows:</P> <P style="margin: 0in; font-family: Arial;"><SPAN>1.</SPAN><SPAN>Firstly, I referenced your data:</SPAN></P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="vlinyulumsft_0-1735111245590.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/1219515iC61A0614E7FAC114/image-size/medium?v=v2&amp;px=400" role="button" title="vlinyulumsft_0-1735111245590.png" alt="vlinyulumsft_0-1735111245590.png" /></span></P> <P style="margin: 0in; font-family: Arial;"><SPAN>2.</SPAN><SPAN>Secondly, I created the following measures:</SPAN></P> <LI-CODE lang="markup">color = VAR aa = SUMMARIZE ( 'Table', 'Table'[Is Final Round], 'Table'[Stage], 'Table'[Stage Status], "color", IF ( 'Table'[Is Final Round] = TRUE () &amp;&amp; [Stage Status] = "Success", "Green", IF ( 'Table'[Is Final Round] = TRUE () &amp;&amp; [Stage Status] = "Unsuccess", "Red", IF ( 'Table'[Is Final Round] = TRUE () &amp;&amp; [Stage Status] = "In Progress", "Yellow", BLANK () ) ) ) ) VAR bb = MAXX ( FILTER ( aa, 'Table'[Stage] = MAX ( 'Table'[Stage] ) ), [color] ) RETURN IF ( ISBLANK ( bb ), "white", bb ) </LI-CODE> <P style="margin: 0in; font-family: Arial;"><SPAN>3.</SPAN><SPAN>Then, I modified the visual settings as follows:</SPAN></P> <P style="margin: 0in; font-family: Arial; font-size: 12.0pt; color: black;">&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="vlinyulumsft_1-1735111298143.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/1219517i2FE30AEDCBDECDC5/image-size/medium?v=v2&amp;px=400" role="button" title="vlinyulumsft_1-1735111298143.png" alt="vlinyulumsft_1-1735111298143.png" /></span></P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="vlinyulumsft_2-1735111298144.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/1219518iE2F7D162B6430274/image-size/medium?v=v2&amp;px=400" role="button" title="vlinyulumsft_2-1735111298144.png" alt="vlinyulumsft_2-1735111298144.png" /></span></P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="vlinyulumsft_3-1735111312900.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/1219519iCD08D41599BC9C53/image-size/medium?v=v2&amp;px=400" role="button" title="vlinyulumsft_3-1735111312900.png" alt="vlinyulumsft_3-1735111312900.png" /></span></P> <P style="margin: 0in; font-family: Arial; font-size: 12.0pt; color: black;">4.Here's my final result, which I hope meets your requirements.</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="vlinyulumsft_4-1735111352259.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/1219522i62217CAE77BD1BDD/image-size/medium?v=v2&amp;px=400" role="button" title="vlinyulumsft_4-1735111352259.png" alt="vlinyulumsft_4-1735111352259.png" /></span></P> <P style="margin: 0in; font-family: Arial; font-size: 12.0pt; color: black;">Please find the attached pbix relevant to the case.</P> <P style="margin: 0in; font-family: Arial; font-size: 12.0pt; color: black;">&nbsp;</P> <P style="margin: 0in; font-family: Arial; font-size: 12.0pt; color: black;">Best Regards,</P> <P style="margin: 0in; font-family: Arial; font-size: 12.0pt; color: black;">Leroy Lu</P> <P style="margin: 0in; font-family: Arial; font-size: 12.0pt; color: black;">If this post <EM><STRONG>helps</STRONG></EM>, then please consider Accept it <EM><STRONG>as the solution </STRONG></EM>to help the other members find it more quickly.</P> <P>&nbsp;</P> Wed, 25 Dec 2024 07:23:19 GMT https://community.fabric.microsoft.com/t5/Developer/Dynamic-Fill-Color-based-on-Multiple-AND-Conditions/m-p/4342739#M58806 Anonymous 2024-12-25T07:23:19Z