Forum Discussion

zibster's avatar
zibster
Helper III
6 years ago
Solved

Dynamic Reference Lines on X-Axis

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 Referen...
Need Help
zibster's avatar
zibster
Helper III
6 years ago

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's avatar
zibster
Helper III
6 years ago

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

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