Out of range data (by filter/slicer) when highlighting a column in graph, shows data as blank

[DanS446]

When you select a column in a graph, like a month in 2023, but then filter data to 2024 (slicer), the highlight on graph will remain, but now you filtered to data where that selection is blank (showing most info below like (blank), i prevented this with DAX tho, so now text hides or numbers shows as 0).

Its easy to click outside the bars or click a new bar to show valid data (BI info suggests you do it), but the users can still do these invalid interactions.

Is there a way reset highlight based on conditions (like main count = 0), or by a button? (that can be a warning message, click here to reset selection). For now i did a message so the user knows they need to click outside or a new bar but doesnt seem very good to me.

You can make a bookmark button to reset a highlight on just the graph, but it will also reset your view if you drilled down on your date hierarchy, this is not desireable.

Below the image shows the bars transparent because the highlight was made on an out of range selection with the data filtered to 2024

[Anonymous]

Hi @DanS446 ,

While Power BI does not currently offer the built-in ability to automatically reset highlights based on data conditions directly, there are several methods that can be considered to improve the user experience:

• Use bookmarks to reset visual status.
• Utilizing DAX and conditional formatting.
• Use visual cues to guide users.

Best Regards,
Adamk Kong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.