Hello,
I created line chart like here:
But i want to now find a diff between first line which is "On Demand" and second line which is "Reservation":
So first adding a dashed line from min point from "OnDemand" , after drowing dashed line for max "Reservation" and as last step, see the diff between them.
Here the link to example model:
https://drive.google.com/file/d/13wn-vSyg5q2mvU5KtWzMSiPZWHDHGxVR/view?usp=sharing
How to achive it?
Best,
Jacek
Hi, @jaryszek, here is what you need to do to achieve the result like in the image below 😉
I'll keep DAX part aside, which was excelently explained by @FBergamaschi and will only focus on the visual one.
Suppose you already have Min and Max lines (calcualted using DAX or even some fixed values). To plot them in addition to the standard lines you need to use "Reference lines" formatting option. Within it, you select "Y-Axis constant line". At this point, you'll get 2 lines you're interested it. Now we need to higlight area between them. However, you can add shade only before or after the a reference line, not between 2 reference lines.
See Step1 in the image above: when I apply shade area with a position "After" it will shade everything from Min line and above. Now, I need to get rid of the shade above Max line. To obtain the result from the step 2 you simply repeat the same for Max line (shade with position after) and select white color. It's important to make transparency equal to 0, otherwise you'll still see some part of shade from Min line, which is above Max.
Hope it helps! See pbix attached for details and good luck with your project!
Hi, @jaryszek, here is what you need to do to achieve the result like in the image below 😉
I'll keep DAX part aside, which was excelently explained by @FBergamaschi and will only focus on the visual one.
Suppose you already have Min and Max lines (calcualted using DAX or even some fixed values). To plot them in addition to the standard lines you need to use "Reference lines" formatting option. Within it, you select "Y-Axis constant line". At this point, you'll get 2 lines you're interested it. Now we need to higlight area between them. However, you can add shade only before or after the a reference line, not between 2 reference lines.
See Step1 in the image above: when I apply shade area with a position "After" it will shade everything from Min line and above. Now, I need to get rid of the shade above Max line. To obtain the result from the step 2 you simply repeat the same for Max line (shade with position after) and select white color. It's important to make transparency equal to 0, otherwise you'll still see some part of shade from Min line, which is above Max.
Hope it helps! See pbix attached for details and good luck with your project!
thank you very much.
I created for the example 2 measures:
OnDemand Measure =
CALCULATE(
SUM(fct_amortizedcosts[CostInBillingCurrency]),
fct_amortizedcosts[PricingModel] = "OnDemand"
)
Reservation Measure =
CALCULATE(
SUM(fct_amortizedcosts[CostInBillingCurrency]),
fct_amortizedcosts[PricingModel] = "Reservation"
)
and created delta:
Delta = [OnDemand Measure] - [Reservation Measure]
But have the issue with figuring out what is a Visual Calc in yuor words ans how toshow this delta properly?:
In a screen it loos like:
(orange line).
How to show this the diff like I shown in the previous screen? It is possible to show as area ?
I have updated example model:
https://drive.google.com/file/d/13wn-vSyg5q2mvU5KtWzMSiPZWHDHGxVR/view?usp=sharing
Best,
Jacek
Hi @jaryszek ,
sorry for late reply, here is how to create a visual calculation, then you can try to format is through the format pane, I am not sure if you can format as an area, it is still in preview
Sorry again for being late, I was traveling
If this helped, please consider giving kudos and mark as a solution
@me in replies or I'll lose your thread
Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page
Consider voting this Power BI idea
Francesco Bergamaschi
MBA, M.Eng, M.Econ, Professor of BI
Thank you,
no problem.
Hmm I am feeling like an idiot and have the issue with implementing this still.
I tried with custom calculation:
but why I can not put measures into it? It should be Delta measure or which one?
https://drive.google.com/file/d/14lpEWK-MQ6JMU5_15WVh8Gv22AiGvdpR/view?usp=sharing
Best,
Jacek
Helpful resources
Fabric Data Days
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Power BI Monthly Update - October 2025
Check out the October 2025 Power BI update to learn about new features.
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
