Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello
is it possible on the same line (curve) to have 2 colors according to a date chosen in a slicer ?
like with this bar graph :
in blue it is the actual, in red the forecast (the data are in different fact tables)
If I convert this graph to lines I get :
But I would not like it to be points but the line like here but suddenly realized with 2 indicators:
An idea ?
Thanks
Hi, @Cobra77
You can try the following methods.
Example data:
Forecast Measure = Var _actul=SUM(Actual[Actual Value])
Return
IF(_actul=BLANK(),SUM(Forecast[Forecast Value]))
Is this the result you expected?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @v-eqin-msft
Thank you for your answer, but we already obtain this result and even by linking the curves, we would like with a single indicator to be able to color from a date the curve of another color, as with the bar chart, and without the have points by putting it in line, just really the curve
User | Count |
---|---|
98 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
58 |