Forum Discussion
Highlight period in a graph
Create a measure that returns a value (e.g., the max of your Y-axis) only for the selected period from the slicer.
HighlightPeriod =
VAR SelectedPeriod = SELECTEDVALUE(Periods[Period])
RETURN
IF(MAX(Periods[Period]) = SelectedPeriod, MAX(YourTable[Value]), BLANK())
Place this measure as a stacked column/bar behind your main chart (make it semi-transparent with color formatting).This creates a shaded/highlight effect only on the selected period.
Responsive ResidentHi PBIDev01
Yes, you can highlight a specific bar in a chart based on slicer selection using conditional formatting with a DAX measure.
Please find this link in order to find the solution
https://coammunity.fabric.microsoft.com/t5/Desktop/Conditionally-format-bar-chart-column-colour-based-on-slicer/m-p/1004275#M476337
Hope this helps 🙌 If it works for you, please give a Kudos 👍 and mark it as Accepted Solution ✅ so others can benefit.
Best regards,
Shashi Paul
Thank you for your answer but I would like to identify the selected period by highlighting maybe the background of it, not the bars that are in the period.