Forum Discussion
take over colored Excel
4 Replies
- Greg_Deckler
Community Champion
You can setup conditiional formatting for table/matrix cells in Power BI but you will have to grab the color codes from the Excel file. There is no magical automation for this.
- amitchandak
Super User
Power Bi takes Excel as data input. I am not sure you can get the color setting to Power Bi
- AnonymousNot applicable
To change color based on value, select a visualization to make it active. Open the Formatting pane by selecting the paint roller icon and then open the Data color card. Hover over the card, and select the three vertical dots that appear and choose Conditional formatting.
select the conditional formatting option by clicking the three vertical dots
In the Default color pane, use the dropdowns to identify the fields to use for conditional formatting. In this example, we've selected the Sales fact > Total Units field and selected light blue for the Lowest value and dark blue for the Highest Value.
settings for conditional formatting by data color
column chart with default colors applied
You can also format the color of the visual using a field that is not part of the visual. In the following image, %Market Share SPLY YTD is being used.
As you can see, although we've sold more units of both Productivity and Extreme (their columns are higher), Moderation has a larger %Market Share SPLY YTD (its column has more color saturation).
- v-lili6-msft
Community Support
Hello @Xneider
You could do conditional formatting in visual power bi, please refer to this:
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting
Best regards
Lin