Forum Discussion
Community ChampionColumn Chart, How best to emphasise specific Column in the chart (Current year)
Hi DebbieE ,
Based on my test, it is not supported in column chart currently. You can come up with a new idea and add your comments there to make this feature coming sooner.
https://ideas.powerbi.com/forums/265200-power-bi-ideas
Best Regards,
KellyDid I answer your question? Mark my post as a solution!
Super UserDebbieE , we have conditional formatting, but that will only work if you have not used legend.
Check if you can see the option of conditional formatting in series color, If yes. Create a measure like this one
Color Date = if(year(FIRSTNONBLANK('Date'[Date],TODAY())) =year(today()),"lightgreen","red")
Please use the axis of the chart in this formula
and then use Field option in conditional formatting
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
https://exceleratorbi.com.au/conditional-formatting-using-icons-in-power-bi/
https://community.powerbi.com/t5/Desktop/FORMAT-icon-set-for-use-in-a-data-card/td-p/811692
- DebbieE
“we have conditional formatting, but that will only work if you have not used legend. “
As above I have used legend, this is why thecolumns are split so I don’t think this will work for me
"Check if you can see the option of conditional formatting in series color, If yes. Create a measure like this one Color Date = if(year(FIRSTNONBLANK('Date'[Date],TODAY())) =year(today()),"lightgreen","red")"
I only have Data Colours for the Legend
It looks like this wont work for me. Are there any other options I can use, bearing in mind the visual above, I have split the column by the Column series
