Data Colours assigned via a measure not displayed in Report in Power BI Service

[HMJSomerset]

I have a report in Power BI Desktop (May 2019) that has several visuals where the data colour is assigned via a simple measure (green if better than last year, red if worse, yellow if the same).  

This is working perfectly in desktop but when I publish up to the Service the visuals just display as one colour with no formatting.

What am I doing wrong?

[v-lili6-msft]

hi, @HMJSomerset 

I have tested on my side, It works well not reproduce the issue.

Could you share your simple sample pbix file for us have a test, there should be something wrong in other.

Best Regards,

Lin

[HMJSomerset]

Sorry - I can't share the original pbix file.  

I will have to create a new file with anonymised data if I am to share it.

[HMJSomerset]

I can't work out how to share the pbix file but I have uploaded screenshots of the desktop and web reports.

To reproduce the error I create two simple measures Total Spend and Total Spend SPLY

Total Spend = SUM('2018-17_MonthlyReport'[Amount])

Total Spend SPLY = CALCULATE([Total Spend],SAMEPERIODLASTYEAR(dimDate[Date]))

I then created another measure:

Spend Colour KPI =

SWITCH(

TRUE(),

[Total Spend] < [Total Spend SPLY], "C73672",

[Total Spend] > [Total Spend SPLY], "009CA6",

"FFFF00"

)

to change the colour if spend was more or less than the same period in the previous year.

I created a stacked column visual plotting Year/Month on X axis and [Total Spend] on Values

Formatting the data colours as conditional formatting

Format by Field value based on field Spend Colour KPI.

As you can see from the pictures in the desktop report the colours change, but in the service they are all the same colour

PBI DesktopPBI Service

[v-lili6-msft · Accepted solution]

hi, @HMJSomerset 

Adjust your formula as below:

Spend Colour KPI = 
SWITCH(
TRUE(),
[Total Spend] < [Total Spend SPLY], "#C73672",
[Total Spend] > [Total Spend SPLY], "#009CA6",
"#FFFF00"
)

For why your formula works well in power bi desktop but not works in power bi service, I have submitted it to power bi product team, I will post it here once I get a reply.

Best Regards,

Lin

[HMJSomerset]

Thanks Lin

I amended the measure to include the #hex colour and now the colours are displayed in the report in the PBI Service as well as the Desktop.

[v-lili6-msft]

hi, @HMJSomerset 

I get this from power bi product team:

The issue here is, the measure the user has is using "C73672", "FFFF00" and "009CA6"  for the color values. Apparently chrome supports hex values like these for colors but the valid hex color format is #value. Edge does not support the values without #. 

User needs to update the measure to return "#C73672", "#FFFF00" and "#009CA6".

Best Regards,

Lin