Forum Discussion
Solved
Slider problems
I have the following calculated DAX table, used on a slider: Future Travel Slider = VAR MaxValue = MAX('Future_Predicted'[Number_Of_Days_Slider]) RETURN ADDCOLUMNS( GENERATESERIES(0, MaxValue, 1...
Hi RichardLinderma,
Please check the below pbix file by using sample data by switching to dropdown in the visual.
If this post helps, then please consider Accept it as a solution to help the other members find it more quickly.
Thank you.
Hi RichardLinderma, I tried to iterate on your problems in Power BI and come up with a solution.
Calculated Table
Future Travel Slider =
VAR MaxPossibleValue =
CALCULATE(
MAX('Future_Predicted'[Number_Of_Days_Slider]),
ALL('Future_Predicted')
)
RETURN
ADDCOLUMNS(
GENERATESERIES(0, MaxPossibleValue, 1),
"Label", "Value " & [Value]
)
Measure for Cards
Maximum days =
VAR SelectedMaxDays =
IF(
HASONEVALUE('code'[account_code]),
CALCULATE(
MAX('Future_Predicted'[Number_Of_Days_Slider]),
USERELATIONSHIP('code'[account_code], 'Future_Predicted'[account_code])
),
CALCULATE(
MAX('Future_Predicted'[Number_Of_Days_Slider]),
ALL('Future_Predicted')
)
)
RETURN
IF(ISBLANK(SelectedMaxDays), 0, SelectedMaxDays)
And as you can see, when i select maximum days is showing 70 and there is no reflection on the Future Travel Slider ![]()
If I answered your question please mark my post as the solution, it helps others with the same challenge find the answer!
Download the Sample Solution File: https://getshared.com/BG3FoAHd
If I answered your question please mark my post as the solution, it helps others with the same challenge find the answer!