take over colored Excel

[Anonymous]

My Source ist an Excel with same colored Cells. I want a colored Excel Cell to be transferred to Power Bi in the same color

[v-lili6-msft]

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

[Anonymous]

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).

[amitchandak]

Power Bi takes Excel as data input. I am not sure  you can get the color setting to Power Bi

[Greg_Deckler]

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.