What Grafana version and what operating system are you using?
Grafana 9.3.2 on Ubuntu 22 LTS
What are you trying to achieve?
I want to visualise past sales and expected/estimated sales in the future. I have them both in one table, if the date of the sale is in the future, it is an expected/estimated sale. If the date is in the past, the sale was made. I want that sales in the future are drawn with different opacity.
How are you trying to achieve it?
I tried using 2 seperate queries in one diagram. Then i use an override to ensure the queries have different opacities. This works for the opacity, sadly the colors of the queries are different and the same product is shown in the legend twice, with different colors
The 2 queries have different colors for the same product and are also twice in the legend. See attached picture, first graph
What did you expect to happen?
The same product (column name) should have the same color
Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.
There were no errors in the UI or logs