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.
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.
Hi sumneshnepalia ,
Another possible way to do this is to create multiple measures that return values with different timestamps, and then you can use conditional formatting.
This way is provided by PaulDBrown, in the post below.
Solved: Conditional Formatting a Line Chart in Power BI - Microsoft Fabric Community
If that still doesn't help, I suggest submitting an idea so that more people can vote for it:
Welcome to Microsoft Fabric Ideas
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.
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.