need help creating a visual

[mikess1281]

This may be the wrong section, I have a request to create two charts in power bi and I am not sure how to alcomipsh the following and need some help.
Chart 1

1) He is wanting to go back four months and include two reference lines for each of the four months – one reference line for the daily 2024 average for the month, and another reference line for the daily 2023 average for the month.  

(the only way that how is the constant reference line, which is does not fit the requirments. I tried missing around with the line combo chart with dax with no luck.)

Chart 2  He wants to add two reference lines to a bar chart of facility . One line will represent the total for the associated facility in 2023, and the other line will represent the total for the facility in 2024.

[Akash_Varuna · Accepted solution]

Hi @mikess1281 For Chart 1, create measures for 2023 and 2024 monthly daily averages using DAX and plot them as lines on a combo chart. Use dynamic calculations to adjust averages for the last four months.

For Chart 2, create measures for 2023 and 2024 facility totals, then add them as reference lines to a bar chart with facilities on the x-axis. Both charts require proper date formatting and relationships for accurate visuals.