Simple Colour Question

[clawre1]

Hi All,

I have set up a report which has a preset slicer on geography (eg England) 

On page 3 of the report I want to show where England ranks out of all the countries in Europe in a standard bar chart so I have turned off the relationship (via Edit interactions) from the slicer to the bar chart. 

Is there a way to keep the slicer (in this case England) highlighted or paint the bar a different colour so it stands out?

As the slicer is changeable so I can't put direct text into the conditional format

Any help would be great - Chris 

[clawre1]

I have set up a report which has a preset slicer on geography (eg England) 

On page 3 of the report I want to show where England ranks out of all the countries in Europe in a standard bar chart so I have turned off the relationship (via Edit interactions) from the slicer to the bar chart. 

Is there a way to keep the slicer (in this case England) highlighted or paint the bar a different colour so it stands out?

As the slicer is changeable so I can't put direct text into the conditional format

Any help would be great - Chris 

[PaulDBrown · Accepted solution]

Check out this thread which tackles a similar challenge:
https://community.powerbi.com/t5/Desktop/Change-color-of-a-bar-based-on-filter/m-p/910090#M436185

[clawre1]

Thanks for everyones help the last post led me to 

Slicer Selection = Var Select_Slicer = MIN('geography slicer table'[WardName])

Return

VALUE(CALCULATE(SUM('table with bar chart data'[Value]), 'table with bar chart data'[WardName] = Select_Slicer))

I then used a conditional format on value not blank - ta da!

Thanks again

[FrankAT]

Hi,

first create a calculated column in which England gets a number identifier by 1 and all other countrys 0.

Marker = IF(Territory[Country] = "England" ; 1 ; 0)

Select the visual > format > data colors > Default color, click on the three dots on the right hand side > Conditional formatting:

Regards FrankAT

[clawre1]

Hi FrankAT,

Thanks but not quite what I am looking for as the England would have to be hard coded into the report. I am looking for something slicer driven, is there a way to write into the datasheet a 1 when a country is slected by the slicer then I could use the conditional formatting?

Cheers Chris

[amitchandak]

Check if this can help

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-filled-maps-choropleths

[clawre1]

Hi Amitchandak,

No sorry I am well versed in mapping, this actually relates to UK Ward level categories but I need to really show a basic bar chart as I have overused the maps in the report already. I chose England vs Europe so it would be easier to explain. Like the chart accent but feeding from a slicer. Thanks however