Dynamic Reference Lines on X-Axis

[zibster]

Hi,

I have a question how can i change the DAX below to display multiple reference lines on a line and clustered column chart?

the example is from great youtube video

Power BI - Dynamic Reference Line on X-Axis

But it is only for one reference line

Thanks Z

InvDate =

var virtual =

        SUMMARIZE(ALLSELECTED(FMT),

        FMT[WE-DATE-3],

            "EINV", sum (FMT[END-INV])

            )

Return

    IF(

        MAX(FMT[WE-DATE-3]) = MAX(InventoryDT[WeekEnd]),

        MAXX(virtual,[EINV]),BLANK()

    )

[v-chuncz-msft · Accepted solution]

@zibster 

You may use the IN operator.

    IF (
        MAX ( FMT[WE-DATE-3] ) IN VALUES ( InventoryDT[WeekEnd] ),

[zibster]

Perfect 🙂 Thanks For Your help.

[rajulshah]

Hello @zibster,

Is the DAX query provided a calculated measure?

Please note that a calculated measure will always return a single value. If you provide some more details as to what values you need to plot as dynamic reference lines, maybe I could help you in a better way.

[zibster]

Hi,

I would like to plot the inventory dates on the chart, the inventory chart is reference as InventoryDT[WeekEnd], these are weekend dates. The data table has calculated inventory levels on weekly basis and the weekend dates for each of the weeks. Within last 52 weeks the facility I am working on  completed actual inventory 2 times but other facility the inventory was done 3 of 4 times. Please let me know if this make sense.

Thanks for Your help

[zibster]

one more thing InventoryDT[WeekEnd] is a calculated column returning weekend dates 

WeekEnd = InventoryDT[INVENTORY_DATE] - WEEKDAY(InventoryDT[INVENTORY_DATE],1)+7