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.
I want to color the line of a chart up to a defined date. The rest of the line should be dashed.
For this I have already created two lines and superimposed them to format them differently. However, the end of the first line is disturbing, because a horizontal line is created.
Is it possible to hide the tail? or to format the same line to defined data sections?
You can hide the blue "tail" by updating your measure so it returns blank for those points (e.g., Year > 2023 or Date > TODAY()).
Pat
Thank you for your message @ppm1 . What should I change?
Please try this measure instead. Note also that filtering a whole table is not best practice, so I removed that too.
Running Total Cost Today =
VAR maxdate =
MAX ( 'PCT'[Period] )
RETURN
IF (
maxdate <= TODAY (),
CALCULATE ( SUM ( PCT[Actual Total Cost (€)] ), 'PCT'[Period] <= maxdate )
)
Pat
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.