Colors are changing when measure gets a new value

[Anonymous]

We are facing the following situation:

We use a measure to calculate values (e.g. sales in %) for the actual month and the values for the actual month of the previous year.

To do that we have “Measure A” for the actual month and “Measure B” for the actual month of the previous year.

In order to simplify the handling for the end user we created a third measure, which shows both calculated values (“Measure A” and “Measure B”) at the same time. However, if the actual month moves forward the color is changing as shown in the screenshot. I assume that is because the months are changing dynamically.

My question is if it is possible to prevent Power BI to assign a new color if the value for “Measure A” and “Measure B” is calculated to a new value?

BTW we are using Power BI Desktop March 2018 for Report Server.

[Greg_Deckler]

Can you provide more detail on this? Would be interesting to experiment with. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490