Forum Discussion

mikess1281's avatar
mikess1281
Regular Visitor
1 year ago
Solved

need help creating a visual

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...
Need Help
  • Akash_Varuna's avatar
    Akash_Varuna
    1 year ago

    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.

Akash_Varuna's avatar
Akash_Varuna
Super User
1 year ago

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.