洞察觀點

Shows you how to use Power BI highlight to emphasize the top three colors in a chart

Shows you how to use Power BI highlight to emphasize the top three colors in a chart-封面

When using Power BI, if you want to color the chart according to different categories or levels, or mark the top three of the bar chart with eye-catching colors, but you don’t know where to start, let’s take a look at this article and learn how to use simple DAX functions to quickly and easily color the chart.

Teaching You How to use Power BI Highlight:

Step 1: The value of the new increment in the data column

Shows you how to use Power BI highlight to emphasize the top three colors in a chart (1)

Step 2:Use the RANKX function to establish sorting

RANKX(<table>, <expression>):

Returns the order in which the expression is arranged, and the calculation of the expression is performed on the current content in the list of values passed in each data column of the specified data table in the arithmetic calculation.

Shows you how to use Power BI highlight to emphasize the top three colors in a chart (2)

Step 3: Set the formatting conditions on the data row of the visual effect

  1. Once you’ve set up the formula, click Format the visuals→ 2. Click on the visual → 3. Click on the configuration formatting condition for the data row → 4. Select the formula you just set in the field

Shows you how to use Power BI highlight to emphasize the top three colors in a chart (3)

Shows you how to use Power BI highlight to emphasize the top three colors in a chart (4)

Step 4:The top three of the chart are highlighted in a bold color

Shows you how to use Power BI highlight to emphasize the top three colors in a chart (5)

After completing the above actions, you can easily mark the color on the chart, and you can mark the color yourself according to the ranking and customer level. In addition, this design can not only improve the aesthetics of the report, but also make the report intuitive and easy to understand, especially in the business report or the dashboard of the situation. All in all, the eye-catching colors of the icons in Power BI not only enrich the presentation of visual effects, but also improve the efficiency and professionalism of data analysis, let’s try this feature together!

KSCC is a management consulting company in Taiwan. Our services include corporate in-house training, consulting, and leadership management.For more information about our corporate services, please feel free to visit our website: https://kscthinktank.com.tw/custom-training/ 

【KSCC Lecture Series】 

【KSCC Online Course Series】 

Facebook
LinkedIn
聯絡我們表單
Scroll to Top
取得最新資訊

訂閱每週最新消息