Mark specific dates on a chart

Question

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?

Appreciate any help!

philiptreacy · Answer

HI&nbsp;Maria9292&nbsp;
I'm still not clear on the actual values you want highlighted.&nbsp; What does the data column of Positive or negative numbers actually look like?&nbsp; The values?&nbsp; Please provide an example.
Is it just 1 or -1?&nbsp; You supplied an mage of a Fact table with a Change column but it wasn't clear if that's what you are trying to plot.&nbsp; Even if it was, which values do you want highlighted?
regards
Phl

philiptreacy · Answer

Hi&nbsp;Maria9292&nbsp;
&nbsp;
Download sample PBIX with data and chart
&nbsp;
Create another series for the highlighted values - for the values you don't want to highlight leave them blank

&nbsp;
Add this Highlight series to the chart then in Format -&gt; Shapes,&nbsp;

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

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

&nbsp;

&nbsp;
Regards
Phil

maria9292 · Answer

Thank you&nbsp;PhilipTreacy !That doesn't work with the way my data is shaped.&nbsp;The second line on the chart is a Running total measure that takes dates from a Date table and values from a Fact table.&nbsp;Measure:Running Total = CALCULATE(&nbsp;&nbsp;&nbsp;&nbsp;SUM('Fact_Table'[Change]),&nbsp;&nbsp;&nbsp;&nbsp;FILTER(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ALLSELECTED(Date[Date]),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ISONORAFTER(Date[Date], MAX(Date[Date]), DESC)&nbsp;&nbsp;&nbsp;&nbsp;))&nbsp;Fact Table:&nbsp;what I managed to do so far ( I took out the second values temporarily):&nbsp;I created a conditional column: if [Change] &lt;&gt; 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.

philiptreacy · Answer

Hi&nbsp;Maria9292&nbsp;
So what values are you actually trying to highlight on the chart?&nbsp; From your images it appeared you wanted to highlight points on the 2 lines?
If you are wanting to use values from the measure won't you just get a line/points that increase in value because it's a Running Total?