Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello,
I am trying to calculate trends using slope and intercept
I am using the following DAX, which is functioning well. However, the issue arises when I have a slicer on the order date. I want the dataset for the query below to also get filtered for that date range when a user applies a start and end date filter on the order date slicer
LINESTX (
ALL('Sales order line fact'[Order date] ),
[Total revenue trend],
'Sales order line fact'[Order date]
)
VAR slope = SELECTCOLUMNS ( line, [Slope1] )
VAR intercept = SELECTCOLUMNS ( line, [Intercept] )
VAR x = SELECTEDVALUE ( 'Sales order line fact'[Order date] )
VAR y = x * slope + intercept
RETURN y
Solved! Go to Solution.
@Ethanhunt123 Hi! Try with:
Revenue trend =
VAR line =
LINESTX (
ALLSELECTED('Sales order line fact'[Order date]), -- This respects the slicer
[Total revenue trend],
'Sales order line fact'[Order date]
)
VAR slope = SELECTCOLUMNS(line, [Slope1])
VAR intercept = SELECTCOLUMNS(line, [Intercept])
VAR x = SELECTEDVALUE('Sales order line fact'[Order date])
VAR y = x * slope + intercept
RETURN y
BBF
I was doing something incorrectly. Your solution worked perfectly. Thank you so much! 🙂
@Ethanhunt123 Hi! Try with:
Revenue trend =
VAR line =
LINESTX (
ALLSELECTED('Sales order line fact'[Order date]), -- This respects the slicer
[Total revenue trend],
'Sales order line fact'[Order date]
)
VAR slope = SELECTCOLUMNS(line, [Slope1])
VAR intercept = SELECTCOLUMNS(line, [Intercept])
VAR x = SELECTEDVALUE('Sales order line fact'[Order date])
VAR y = x * slope + intercept
RETURN y
BBF
I have tried this but I don't think so this is working see below
Data without the filter on date
Data with the filter on the date - From Jan 1 till Sept
Values are the same as above. My assumption is if I am changing dataset then values should also get change
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
22 | |
7 | |
6 | |
6 | |
6 |
User | Count |
---|---|
27 | |
12 | |
10 | |
9 | |
6 |