Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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).
Power Bi takes Excel as data input. I am not sure you can get the color setting to Power Bi
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
117 | |
104 | |
77 | |
73 | |
50 |
User | Count |
---|---|
145 | |
109 | |
108 | |
90 | |
64 |