Maybe not matching the topic completely, but related: If a colour code in Excel is e.g. #AABBCC, it needs to be turned around to #CCBBAA for Power BI to show the same colour (sigh). Or, less ambiguous: #A1B2C3 => #C3B2A1 ;-)