Colour Format Measure - Multiple % Change Measures

Question

Hi, I've got lots of metrics on my social media accounts and need the % Change colours formating. Since we have different brands, I want the % changes to be formatted in colour. However, I am using the Card "new" to visualise the metrics and reference values for the % Change.&nbsp; However, it will take a very long time using the reference values formatting as there are 4 "% Changes": TV vs. Last year, prev. month vs. month prior, qtr vs. last qtr, last qtr vs. YAG. Then I have the following metrics: Followers, reach, sentiment, shares, comments, likes, engagements......&nbsp;&nbsp;Is there an easy measure I can use as the colour format? I tried the below but it did not work...Colour Format = SWITCH(TRUE(),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; [Engagement Rate (% chg qtr vs. prev. qtr.)] &gt;= 0.0, "#73B761",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; [Engagement Rate (% change vs. YAG)] &gt;= 0, "#73B761",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; [Engagements (% change qtr vs. YAG)] &gt;= 0, "#73B761",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; [Engagements (% chg qtr vs. prev. qtr.)] &gt;= 0, "#73B761",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; [Followers (% change qtr vs. prev. qtr.)]&gt;= 0, "#73B761",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; [Followers (% change qtr vs. YAG)] &gt;= 0, "#73B761",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; [IG Post Saves (% chg qtr vs. prev. qtr.)]&gt;= 0, "#73B761",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; [IG Post Saves (% chg qtr vs. YAG)]&gt; 0, "#73B761",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; [Likes + Reactions (% chg qtr vs. YAG)]&gt; 0, "#73B761",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; [Likes + Reactions (% chg vs. prev. qtr.)]&gt; 0, "#73B761",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; [Net Sentiment (chg qtr vs. prev. qtr.)]&gt; 0, "#73B761",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; [Net Sentiment (chg qtr vs. YAG)]&gt; 0, "#73B761",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; [Reach (% chg qtr vs. prev. qtr.)]&gt; 0, "#73B761",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; [Reach (% chg qtr vs. YAG)]&gt; 0, "#73B761",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; [Shares (% chg qtr vs. prev. qtr.)]&gt; 0, "#73B761",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; [Shares (% chg qtr vs. YAG)]&gt; 0, "#73B761",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; [Video Views (% chg qtr vs. prev. qtr.)]&gt; 0, "#73B761",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; [Video Views (% chg qtr vs. YAG)]&gt; 0, "#73B761",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; [Engagement Rate (% chg qtr vs. prev. qtr.)] &lt;= 0.0, "#D82C20",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; [Engagement Rate (% change vs. YAG)] &lt;= 0, "#D82C20",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; [Engagements (% change qtr vs. YAG)] &lt;= 0, "#D82C20",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; [Engagements (% chg qtr vs. prev. qtr.)] &lt;= 0, "#D82C20",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; [Followers (% change qtr vs. prev. qtr.)]&lt;= 0, "#D82C20",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; [Followers (% change qtr vs. YAG)] &lt;= 0, "#D82C20",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; [IG Post Saves (% chg qtr vs. prev. qtr.)]&lt;= 0, "#D82C20",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; [IG Post Saves (% chg qtr vs. YAG)]&lt; 0, "#D82C20",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; [Likes + Reactions (% chg qtr vs. YAG)]&lt; 0, "#D82C20",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; [Likes + Reactions (% chg vs. prev. qtr.)]&lt; 0, "#D82C20",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; [Net Sentiment (chg qtr vs. prev. qtr.)]&lt; 0, "#D82C20",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; [Net Sentiment (chg qtr vs. YAG)]&lt; 0, "#D82C20",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; [Reach (% chg qtr vs. prev. qtr.)]&lt; 0, "#D82C20",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; [Reach (% chg qtr vs. YAG)]&lt; 0, "#D82C20",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; [Shares (% chg qtr vs. prev. qtr.)]&lt; 0, "#D82C20",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; [Shares (% chg qtr vs. YAG)]&lt; 0, "#D82C20",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; [Video Views (% chg qtr vs. prev. qtr.)]&lt; 0, "#D82C20",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; [Video Views (% chg qtr vs. YAG)]&lt; 0, "#D82C20")&nbsp;Example of the report:&nbsp;

rajendraongole1 · Accepted Answer

Hi&nbsp;Alpesh&nbsp;- you can simplify the color formatting by using a dynamic approach that doesn't require you to manually check each metric.
create each of your metrics has a corresponding % change measure. I have just segregatted the above measure dynamically to pic the same hexacode. please check and use below:
&nbsp;
Color Format = SWITCH(TRUE(),SELECTEDVALUE([% Change Followers]) &gt; 0, "#73B761",SELECTEDVALUE([% Change Reach]) &gt; 0, "#73B761",SELECTEDVALUE([% Change Sentiment]) &gt; 0, "#73B761",SELECTEDVALUE([% Change Shares]) &gt; 0, "#73B761",SELECTEDVALUE([% Change Comments]) &gt; 0, "#73B761",SELECTEDVALUE([% Change Likes]) &gt; 0, "#73B761",SELECTEDVALUE([% Change Engagements]) &gt; 0, "#73B761",SELECTEDVALUE([% Change Followers]) &lt;= 0, "#D82C20",SELECTEDVALUE([% Change Reach]) &lt;= 0, "#D82C20",SELECTEDVALUE([% Change Sentiment]) &lt;= 0, "#D82C20",SELECTEDVALUE([% Change Shares]) &lt;= 0, "#D82C20",SELECTEDVALUE([% Change Comments]) &lt;= 0, "#D82C20",SELECTEDVALUE([% Change Likes]) &lt;= 0, "#D82C20",SELECTEDVALUE([% Change Engagements]) &lt;= 0, "#D82C20")
&nbsp;
you can reuse the Color Format measure for each one if you have multiple new card visual, the above approach helps and saves the time.
&nbsp;
Hope it helps.

Forum Discussion

Colour Format Measure - Multiple % Change Measures

1 Reply

Related content

Measure

Multiple measures in matrix by year

DAX Measure

How to show multiple metrics/measures in a visual?

Measure 'Contains' multiple.