Forum Discussion

Maria9292's avatar
Maria9292
Helper II
5 years ago

Mark specific dates on a chart

I have 2 tables with different values and a Date table to connect them. I need to highlight a certain values from one of the tables on a double line ctart.     How can I do that?   Appreci...
Need Help
PhilipTreacy's avatar
PhilipTreacy
Super User
5 years ago

Hi Maria9292 

 

Download sample PBIX with data and chart

 

Create another series for the highlighted values - for the values you don't want to highlight leave them blank

 

Add this Highlight series to the chart then in Format -> Shapes, 

 

turn on Customize Series.  For the Highlight series, set the Stroke Width to 0

 

and turn on Show Marker.  Set the marker color and size as you wish.

 

 

Regards

Phil

Maria9292's avatar
Maria9292
Helper II
5 years ago

Thank you PhilipTreacy !

That doesn't work with the way my data is shaped. 

The second line on the chart is a Running total measure that takes dates from a Date table and values from a Fact table.

 

Measure:

Running Total =
CALCULATE(
    SUM('Fact_Table'[Change]),
    FILTER(
        ALLSELECTED(Date[Date]),
        ISONORAFTER(Date[Date], MAX(Date[Date]), DESC)
    )
)

 

Fact Table:

 

what I managed to do so far ( I took out the second values temporarily):

 I created a conditional column: if [Change] <> null then 1 else null, but what I need is if the there is a value in the Fact_Table[Change] (or if Fact_Table[Change] in not blank) then take the value from the Running total measure.