Hi deepak_d03 

To implement this, you can use a slicer in Power BI to filter the desired cities, and the matrix visual will dynamically update to show the selected cities along with their average temperatures.

• Add a Slicer

  • Drag the City column to a slicer visual.
  • Enable Multi-select for selecting multiple cities.

• Create a Measure

  • Write this DAX formula:

Average Temperature = AVERAGE('YourTable'[Temperature])
​

• Set Up the Matrix Visual

  • Add City to Rows.
  • Add the Average Temperature measure to Values.

• Test

  • Use the slicer to select cities.
  • The matrix updates to show only the selected cities with their average temperatures.

Did I answer your question? Mark my post as a solution, this will help others!

If my response(s) assisted you in any way, don't forget to drop me a "Kudos" 🙂

Kind Regards,
Poojara
Data Analyst | MSBI Developer | Power BI Consultant
Please Subscribe my YouTube for Beginners/Advance Concepts: https://youtube.com/@biconcepts?si=04iw9SYI2HN80HKS