Forum Discussion
Conditional formatting a multi line chart direct query
thanks Anonymous .
I thought about that approach but got it working by sorting the dates ascending (to keep todays line on top) and using theme (Define 8 & 7 color as red and rest blue).
Since my data will always return 7 dates this solution works perfectly for now.
Super UserPlease share a simplified version of your PBIX file (in English) without sensitive data. You can upload it to a public cloud service like OneDrive, Google Drive, or Dropbox and share the link. This will help in understanding your data structure and the issue, allowing for more precise guidance.
thanks Kedar_Pande for reply, I have following line chart showing each line for multiple days of data
X axis - timestamp of dayY axis - total volumes
Legend - Date
requirement is to highlight latest date's line to be more thicker and red, rest all lines should be more transperent and thin.
Data is in following tabular format
Hi sumneshnepalia ,
Unfortunately, conditional formatting is not available when there is a Legend field. However, you can manually change the format of the latest date line, for example, as below, I have bolded 18/10/2024 and changed the color to red.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous thanks for your reply.
Unfortunately it hardcodes these changes to date, so when the date changes it keeps the highlighting to 18/10/24 in your example, not to today's date
I have used theme as a workaround to make sure first line is always red, but cant change the thickness and its bit fiddly.