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
rajulshah's avatar
rajulshah
Resident Rockstar
6 years ago

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'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