Forum Discussion
Helper IIHow to Configure Card Visual for selected day Value and Line Chart for selected month's Daily Values
Hi Experts,
I have PBIX Report, with Three Filters: Year, Month and Day and Two Cards and Two Line Charts Visualzation.
Visual Requirements:
1) Card Visuals : Display the value for seleted day in Day Filter.
2) Line Chart: Display daily values for the seleted month in Month Filter.
How can I configure the Card Visual to show seleted day value and the Line Chart to show the daily values for the seleted month?
Attached is the PBIX
Card and LineCharts.pbix
Thank you!
pls try to set up the visual interactions between filter and visual.
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.
2 Replies
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.
ryan_mayuSuper User
pls try to set up the visual interactions between filter and visual.