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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
85 | |
85 | |
69 | |
67 | |
63 |
User | Count |
---|---|
213 | |
124 | |
117 | |
81 | |
75 |