Forum Discussion
How can I create a bar chart that shows the difference between two values according to their dates
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
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)
2 Replies
- danextian
Super User
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)