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
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Anonymous , in case you are not using legend and only using one measure you will be able to see conditional formatting.

You have created an independent slicer. Not coming from the table or joined to the table

 

create a color meausre like given below and use that in conditional formatting with "Field value" option

if(FIRSTNONBLANK(Table[locality],"true")= selectedvalue(locality[locality],"green","blue")

 

https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-numbers-in-the-column
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values

 

 

  • 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.