Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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 |
---|---|
85 | |
76 | |
73 | |
70 | |
56 |
User | Count |
---|---|
104 | |
99 | |
93 | |
78 | |
69 |