Forum Discussion

johnmelbourne's avatar
johnmelbourne
Helper V
3 years ago
Solved

Conditional format bar chart by slicer selection

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

 

 

 

Need Help
  • Arul's avatar
    Arul
    3 years ago

    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

     

     

     

     

2 Replies

  • Arul's avatar
    Arul
    Super User
    3 years ago

    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

     

     

     

     

  • johnmelbourne's avatar
    johnmelbourne
    Helper V
    3 years ago

    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