PBI Visualization

Hi tan_thiamhuat ,

This is a great question and a pretty common challenge when visualizing overlapping time periods in Power BI. What’s happening in your graph is that April and May from two different years (2024 and 2025) are being plotted on the same axis, so their values are stacking up and creating artificial peaks.

Here’s what you can do to show this data more accurately:

1. Combine Year and Month in Your Axis:
   Instead of just using "Month" as your x-axis, create a new column in your data for "Year-Month" (for example, 2024-04, 2024-05, 2025-04, 2025-05). This way, Power BI will treat each month from each year as a separate point, and you won’t get overlapping values.

2. Use a Hierarchical Axis:
   In Power BI, you can set up your axis as a hierarchy: Year > Month. This lets you expand or collapse the data to see trends by year and by month, without mixing the same months from different years.

3. Color/Legend for Data Types:
   Since you have "Cancelled Booking" and "New Booking", make sure these are shown in the legend as separate lines or bars, so it’s clear which series is which.

4. Check for Duplicates:
   Double-check your data to make sure April and May data from both years are not being aggregated together. Sometimes, if you only use the month name, Power BI will add all "April" values together, regardless of year.

How to create a Year-Month column in Power BI (DAX example):

YearMonth = FORMAT([YourDateColumn], "YYYY-MM")

Use this new "YearMonth" column as your x-axis.

By making these adjustments, your visualization will accurately reflect the trends for each period without creating misleading peaks.

If you want, you can share a sample of your data model or a screenshot of your current Power BI setup, and I can give more tailored advice.

Hope this helps you get a much clearer and more truthful chart!