Forum Discussion
Conditional formatting a multi line chart direct query
I have a multiline chart to show volumes by each date built on direct query dataset, requirement is to highlight the latest date line and make it look bigger or identifiable.
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.
6 Replies
Please 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.
