Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Highlight selected bar in a column chart

Hi All, I have got a column chart with 79 geographies and a slicer with the 79 geographies. The column chart is not dependent on the slicer however there are other visualisations in the page that ar...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi amitchandak,

 

I have followed your instructions and created a new table with only the locality column. I have used this column for the slicer. However after I created a new measure using your formula it did not work. Can you please let me know what am I doing wrong? Thanks a ton for your assistance. 

My formula - 

Colour = IF(FIRSTNONBLANK(Sheet1[Locality],"true") = SELECTEDVALUE(Locality[Locality]),"green","blue")

 

Here is the link for the updated .pbix file - https://1drv.ms/u/s!AubIV2PXG9p4gqhykbbmeMfFYlChCw?e=w6UABf

 

 

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi amitchandak,

    Thanks a lot for the quick response and solution. Greatly appreciated.  

    I checked your version on Page 2 and my version with the solution that you provided initially, they both were same but for some reason it wasn't working. I removed the chart and slicer and redid it, Voilà it worked. 

     

    You are a champ. Thank you.

  • gerard-kouadio's avatar
    gerard-kouadio
    Helper I
    4 years ago

    Hello

    I followed what you did. When I select a modality at the filter level, only one bar is displayed. how to solve this ? Thanks