Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

take over colored Excel

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

 

4 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity 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.

     

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

     

  • Anonymous's avatar
    Anonymous
    Not 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).