Forum Discussion
How to Configure Card Visual for selected day Value and Line Chart for selected month's Daily Values
- 2 years ago
pls try to set up the visual interactions between filter and visual.
- Anonymous2 years ago
Hi puru85 ,
Thank you for ryan_mayu answer , and I have other suggestions for you:
Below is my table:You can create two measure:
Measure = SELECTEDVALUE('Table'[Day]) Measure 2 = VAR _month = SELECTEDVALUE('Table'[Month]) RETURN CALCULATE(MAX('Table'[Day]),FILTER('Table','Table'[Month] = _month))and click the visual interaction:
The final output is shown in the following figure:
Best Regards,
Xianda Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi puru85 ,
Thank you for ryan_mayu answer , and I have other suggestions for you:
Below is my table:
You can create two measure:
Measure = SELECTEDVALUE('Table'[Day])
Measure 2 =
VAR _month = SELECTEDVALUE('Table'[Month])
RETURN
CALCULATE(MAX('Table'[Day]),FILTER('Table','Table'[Month] = _month))
and click the visual interaction:
The final output is shown in the following figure:
Best Regards,
Xianda Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.