What is the use of highlighting the max value in a visual?
Highlighting the maximum value in the leftmost Bar Chart instantly improved the value of the visual. It gives us a quick insight into which country sold the maximum quantity.
Can value change with the slicer?
Yes, the value and color can change according to the selected slicer value. For ex: – If we select the year 2021 the quantity sold in the max country will be “USA” and for yr-2020, it will be “Germany”.
Step 1: – Create a simple bar Chart.
STEP 2: – Create a measure.
Maxsale =
VAR shipcountry= ALL(Orders[ShipCountry])
VAR MaxValue= MAXX(shipcountry, CALCULATE(SUM(Orders[_Sales])))
RETURN
IF(SUM(Orders[_Sales]) = MaxValue,”Blue”,”Grey”)
Below is the explanation:
# Name of the measure
Maxsale =
# Variable shipcountry to select all the country
VAR shipcountry = ALL(Orders[ShipCountry])
# Variable MaxValue to find the maximum sale of all the country
VAR MaxValue= MAXX(shipcountry, CALCULATE(SUM(Orders[_Sales])))
# On applying to the bar chart, if the quantity of the item is equal to the maximum value, return Blue or else grey.
RETURN
IF(SUM(Orders[_Sales]) = MaxValue,”Blue”,”Grey”)
Step 3: Under the Visualizations tab of the bar chart, Choose the Visual tab. Select Columns and then choose Colours.
Click the conditional formatting (fx) button next to the default color option.
Under format style, Choose Field Value
Under the field value, select the DAX measure we created.
Umesh Gupta
Data Analyst
Addend Analytics
Addend Analytics is a Microsoft Gold Partner based in Mumbai, India, and a branch office in the U.S. Addend has successfully implemented 100+ Microsoft Power BI and Business Central projects for 100+ clients across sectors like Financial Services, Banking, Insurance, Retail, Sales, Manufacturing, Real estate, Logistics, and Healthcare in countries like the US, Europe, Switzerland, and Australia. Get a free consultation now by emailing us at [email protected] or Contact us.
The post Highlight the max value in the Bar chart /visual. appeared first on Addend Analytics.