Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
manish-tripathi
Frequent Visitor

Representing Yearly Variance in Power BI Line Chart

Hi,

I want to create a visual that shows the variance between the previous year's data and the current year's data in a line chart, similar to the attached image.

 

In the visual, the black line represents the current year's data points for each month. The areas filled with green or red color represent the variance between the current year's data and the previous year's data. Green areas indicate months where the current year's data is higher than the previous year's data, while red areas indicate months where the current year's data is lower.

 

How can I represent this in a stock visual in Power BI? I think we can do this using error bands or error bars, but I am not sure how to implement it. Currently, I am using a custom visual from Zebra BI, which I want to replace.

Thank you.


Visual example:

manishtripathi_0-1720413538049.png

The visual is a timeline comparison of all KPIs, showing the variance between the current year's data and the previous year's data. Here’s a detailed explanation:

  1. Line Chart Representation:

    • The black line represents the current year's (CY) data points for each month.
    • Each data point along the line corresponds to a specific month's value, marked with a numeric label (e.g., 6.8M for January 2021, 670.04K for February 2021).
  2. Variance Representation:

    • The areas filled with green or red color represent the variance between the current year's data and the previous year's (PY) data.
    • Green areas indicate months where the current year's data is higher than the previous year's data.
    • Red areas indicate months where the current year's data is lower than the previous year's data.
  3. Axis and Labels:

    • The x-axis shows the timeline from January 2021 to January 2022.
    •  
  4. Data Points and Variance:

    • Each month has a labeled data point showing the current year's KPI value.
    • The variance is visually represented by the shaded areas between the line and the baseline, with the color indicating the direction of the variance (positive or negative).

Overall, this visual effectively shows both the current year's performance and how it compares to the previous year, highlighting significant increases or decreases with the colored areas.


3 REPLIES 3
lbendlin
Super User
Super User

Have you tested that visual on your business users?  Feels like it is not getting the point across.  A simple line chart with a line for each year and the X axis showing the day of the year seems to be much more suited for the discussion.

Hi This is a requirement from Business user, we are already using Zebra BI Charts, and are now trying to replace them so save on costs

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors