matrix rows displayed from the slicer selection

[deepak_d03]

I need to show the average temparature across multiple cities. There are so many cities and I don't want to display all of them. The plan is to select the desired cities via a slicer so those selected cities will be displayed in the matrix visual along with the average temperatures. How do I do that? 

[Kedar_Pande]

@deepak_d03 

You can achieve this by using a slicer and a measure:

Drag the column containing city names to the slicer visual.

Create a Measure for Average Temperature: 

Average Temperature =  AVERAGE('TemperatureData'[Temperature])

Add Fields to the Matrix Visual:

Drag the City column to the Rows field.
Add the Average Temperature measure to the Values field.

💌 If this helped, a Kudos 👍 or Solution mark would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.

I tried to create a sample pbix file like below.

[Poojara_D12]

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