Forum Discussion
Multi Line chart color and stroke
Hello I am not sure if this is possible in Power BI. The goal is to set the color and stroke size based on the date column. The date that = Today () will always show up Yellow with the stroke size of 12. And so on though the rest of the 8 days. Currently I can manually set up the view I want however as soon as Power Refreshes tomorrow the color and stroke size will change. I already checked conditional formatting, this is not an option with multiple line charts. Does anyone have any suggestions on how I can get the chart to format to stick?
Thank you
Joanna Whitley
Hi Jwhit15
This is a known issue, please vote for it here:and this idea too :
https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=bf62a5fa-d376-ed11-a76e-281878bd0909I voted for both of them.
According to the attempt to get some solution
You can try the linked workaround, I haven't tested it yet, but it seems that there is a chance that it can work:
https://www.youtube.com/watch?v=-FG0DSSAr60If not, I think there is just no way to resolve it.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
3 Replies
- Ritaf1983
Super User
Hi Jwhit15
This is a known issue, please vote for it here:and this idea too :
https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=bf62a5fa-d376-ed11-a76e-281878bd0909I voted for both of them.
According to the attempt to get some solution
You can try the linked workaround, I haven't tested it yet, but it seems that there is a chance that it can work:
https://www.youtube.com/watch?v=-FG0DSSAr60If not, I think there is just no way to resolve it.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Hello
Unfortunately, the provided solutions did not fix the issue of the lines changing colors or size. However, a solution was found. A measure to make the data label static even as the dates change. In short today will show up as T, yesterday will show up as T-1 and so on. With data labels that never change I was able to manually format the size and color of each line.
Thank you for your help
Joanna
Jwhit15 can you please elaborate how did you achieve this?
Did you add Date label as legend?
