In this blog you will understand “How to highlight Maximum & Minimum values in a Power BI column chart?”.
Let’s get started-
Download Sample dataset- Global_superstore_2016.xls
Following these steps-
Step-1: Import Orders dataset from Global superstore file.
Step-2: Now add one clustered column chart in report canvas with some columns.
Step-3: You can see in above chart “Africa” has minimum sales & “Asia Pacific” has Maximum sales.
Step-4: Now follow these colors to highlight min & max values on column chart –
- For minimum sales, color = Red
- For maximum sales, color = Green
- Others, color= Grey
Step-5: Create a measure with below DAX code-
Max_Min Color = VAR GetAllMarket = ALLSELECTED(Orders[Market]) VAR GetMaxValue= MAXX(GetAllMarket, CALCULATE(SUM(Orders[Sales]))) VAR GetMinValue= MINX(GetAllMarket, CALCULATE(SUM(Orders[Sales]))) RETURN IF(SUM(Orders[Sales]) = GetMaxValue,"#00b300", IF(SUM(Orders[Sales])= GetMinValue, "#ff0000","#D3D3D3") )
Step-6: Select chart & go to format bar> Data color > Click on fx icon.
Step-7: Conditional formatting – Data colors window appears, set below options-
Format by: Select Field value
Based on field: Select measure
Step-8: See the final result.
Refer more Power BI Post – Power BI
Hope you enjoyed the post. Your valuable feedback, question, or comments about this post are always welcome.