Forum Discussion
Data Refresh
I have made a bar chart out of some data. The target company is highlighted in red. Now, if I change my data in the excel sheet(with a different list of companies and a different target) and then cl...
Hi Saloni,
In Power BI, there is no OOTB feature for us to specify color based on a condition for the chart visual. So in your scenario, each time the data is refreshed and tartget is chnaged, you need to highlight the new target manually.
To work around the issue, you can try to add one column field in the Excel file to identify the target, then use the combo chart (eg: Line and clustered column chart), place the this new column as line values.
Best Regards,
Qiuyun Yu