Forum Discussion
Solved
Dynamic Baseline for Percentage Difference
Hi, I have the following formula: Revenue % difference from 1H 2019 =
VAR __BASELINE_VALUE =
CALCULATE(
[Revenue],
'Revenue by Product'[Period] IN { "1H 2019" },
ALL('Revenue b...
Hi trailblazer2022 ,
You will need a dim table like below:
column1 column2
1H 2019 1
2H 2019 2
1H 2020 3
2H 2020 4
Then use column1 as x-axis and replace { "1H 2019" } to selectedvalue([ column2])+1/-1
Best Regards,
Jay
You are describing the basic feature of filter context.
Please provide sanitized sample data that fully covers your issue.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523