Conditional formatting on the X-axis
Hi everyone, I am trying to do a report that will automatically update at the start of each month. Within this report there are some charts, like the one attached. For the graph selected i want it to match the legend below using conditional formatting. This is because every month i want the colour to remain the same, whereby the earliest month in the data set is orange, the latest month in the data set is blue and the other month is black. I have been finding it difficult to write the correct DAX that will do this. Is it possible or is there perhaps a way to work around it. I am also attaching two more screenshots if they help? Any help would be appreciated Thank you, Luke
