Performance by Month (Selected Month in Red)

Solution: Highlight Selected Month Bar in Red
Concept:

• Use two measures
• One measure shows all months (default color)
• Second measure shows only the selected Month–Year
• Overlay both in the same chart
• Color the selected one Red

Step 1 - Base Measure:
Total_Value = SUM ( 'Table'[Value] )

Step 2 - Selected Month Measure (returns value only for selected month):
Selected_Month_Value =
VAR SelMonth = SELECTEDVALUE('Table'[Month])
VAR SelYear = SELECTEDVALUE('Table'[Year])
RETURN
IF (
MAX('Table'[Month]) = SelMonth &&
MAX('Table'[Year]) = SelYear,
[Total_Value],
BLANK()
)

Step 3 - Build the Visual:

• Clustered Column Chart
• Axis >> Month
• Values >>
• Total_Value
• Selected_Month_Value

Step 4 - Format Colors:

• Total_Value >> Blue
• Selected_Month_Value >> Red
• Power BI automatically overlays the red bar on top of the blue one.

Step 5 - Keep “Edit interactions → None”

• Works perfectly
• All months stay visible
• Only selected month turns red

Why this works (important)

• Slicer still filters context (even when visual interaction is off)
• We’re detecting slicer state, not filtering the chart
• BLANK() hides non-selected bars for the red measure

Result:

• All months visible
• Selected Month + Year highlighted in Red
• No custom visuals
• High performance
• Works with multiple slicers (Car, Year, Month)

=================================================================
Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Jaywant Thorat | MCT | Data Analytics Coach
LinkedIn: https://www.linkedin.com/in/jaywantthorat/
Join #MissionPowerBIBharat = https://shorturl.at/5ViW9
#MissionPowerBIBharat
LIVE with Jaywant Thorat from 10 Jan 2026
8 Days | 8 Sessions | 1 hr daily | 100% Free