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.
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.