Curve color depending on its position relative to another
I have 2 series of values: val1 and val2, and a column with dates. I want to show a graph with a date x-axis, and the 2 curves corresponding to val1 and val2. The 2nd curve should be red if below curve1 and green if above. The first solution I came with is to create 2 columns corresponding to val2 in my database: val2_up would have the same value as val2 if above val1, and would be NULL if below val1. Similarly, val2_down would have the same value as val2 if below val1, and would be NULL if above val1. The problem if I choose this solution is that I cannot add filters on family, category and type. Actually I could, but as PowerBI computes the total, If I choose to show for example only family1, it would compute 2 totals: the first with every values below val1 and the 2nd with every value above val1. Thus it would show 2 curves for val2, whereas I would only want 1: If you have any other idea, I would appreciate if you could share it
Lack of colours in dispersion graph (analicing differences)
Hello, In graph column using right bottom -> analyze decrease then click on dispersion graph. In desktop I can see the colours (red and green) Then I publish the report and in web versión the graph appears in white (without colours): I have tryed with differents browsers (FireFox, Chrome and Edge) and neither it works. Can you help me whith this issue? Regards.
