Conditional format bar chart by slicer selection

[johnmelbourne]

Hi,

I have the following design, and I want the specific provider's bar highlighted when selected in the slicer. 

At the moment I have the bar chart not filtering due to edit interactions turned off.

Is there a way to do this?

Any assistance greatly appreciated. PBIX file linked below.

Filename Size URL Expires at

conditionalformatbarchart.pbix

126.59 KB

https://tmpfiles.org/dl/953823/conditionalformatbarchart.pbix

2023-02-22 07:57 UTC

[johnmelbourne]

Thanks for your reply, worked execellently to format the bars in the visual.

Then just had to create a new measure for the visual I wanted to filter such as:

Total complaints (disconnected) using VALUES =

    VAR SelectedProviders = VALUES(Slicer[Provider])

RETURN

    CALCULATE(

        [Total complaints],

        FILTER(

            Data,

            Data[Provider] IN SelectedProviders

        )

    )

To use the value in the disconnected slicer to create a "filtered" result in the other visual.

Many thanks again @Arul 

[Arul · Accepted solution]

@johnmelbourne ,
refer video in this link:https://www.youtube.com/watch?v=DT3XTcXJxo4 

1. Create a duplicate table of the column which is using in the slicer.

2. Write the below measure,

Conditional Formatting = 
VAR _selectedBank = VALUES('Table 1 (Slicer)'[Bank])
VAR _result = IF(SELECTEDVALUE('Table 1'[Bank]) IN _selectedBank,1,0)
RETURN _result

3. In the slicer use the column from duplicated table i.e. from the slicer table,

4. Now bring the columns from source table for the visualization (bar chart),

5. Now click on any of the values in the slicer would make the bar chart interactive,

Thanks,

Arul