How can I create a bar chart that shows the difference between two values according to their dates

[Anonymous]

Hello! I'm new to PowerBI and can't figure this one out.

I have an Excel datasheet with 4 main columns, the first has the product name, the second has the some parameters related to the products, the third has the value of thoses parameters, and the last has the year when that parameter was measured.

I need to create a visual that shows how muc the parameters have changed according to the filtered product and time (eg: if I choose to filter 2022 and 2021 and product X, the visual would show the difference between the values of the parameters measured on those two years for that product).

I was trying to do it by creating a bar chart and the two filters (for year and product), but can only find how to get the sum or take the average of the values. Is there a way to get the difference or subtraction?

Here's how I tryed and the Excel sheet:

AverageSumDatasheet

[danextian · Accepted solution]

Hi @Anonymous ,

Give your data screenshot, I would use a formula similar to this:

Diff = 
VAR __PREV =
    CALCULATE (
        SUM ( 'Table'[Measured] ),
        ALL ( 'Table'[Year] ),
        'Table'[Year]
            = MAX ( 'Table'[Year] ) - 1
    )
RETURN
    SUM ( 'Table'[Measured] ) - __PREV

You can see in the image below that measure above returns the difference between two years (Product A for 2022-- 3.48-.047 = 3.01)

[Anonymous]

Thank you so much! It worked even better than what I was initially trying to do 😁