How to Configure Card Visual for selected day Value and Line Chart for selected month's Daily Values

[puru85]

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!

[ryan_mayu · Accepted solution]

pls try to set up the visual interactions between filter and visual.

https://learn.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions?tabs=p...

[Anonymous · Accepted solution]

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_mayu · Accepted solution]

pls try to set up the visual interactions between filter and visual.

https://learn.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions?tabs=p...