Highlight based on slicer

[Verbani]

Hi all,

I'm tryint to create something that seems rather simple, but I can't find the solution.

I'm creating a report in Power BI with on top a slicer on Region.

This will filter some visuals on the page, but there is also a bar chart that shows all the regions. (Interactivity is turn of between slicer and bar chart.)

All fine till now. But the user want's that in this bar chart with all regions, the selected region is highlighted. 

Any idea's on how to do this? Can't check the selectedValue in DAX since the slicer is not applied...

Regards,

Nico

[Anonymous]

@Verbani,

The method I can think of is to add another visual such as pie chart which can be filtered by slicer in the report page, after selecting value in the slicer, then click on the pie chart. Bar chart will be highlighted in this case.


Regards,
Lydia

[Verbani]

Dear,

This is not really a workeable solution.

The report is designed to inform our customers. I don't want to add additional visuals without value and cluttering my report to add this functionality.

Meantime I did find a workaround that works for me.

Replace the slicer with a Grid visual. this will return the list of values I want to select in. 

Selecting a value there does get the column highlighted. And this without adding an additional pie visual, and performing 2 clicks to highlight.

Regards,

Nico