Change a column of a table based on a filter

user_9517769 0
Viewed 99

I have a filter containing City/Country :

enter image description here

I created a table Filters with a column Filtering containing City and Country like above.

When selecting City I want to display the target by city:

enter image description here

When selecting Country I want to display the target by country:

amirabedhiafi_2-1634393001899.png

Knowing that I have other filters in the same page like semester ...

dax powerbi
1 Answers

Considering your example, one way to achieve this output is to use Matrix visual instead of a Table visual.

  • Add Target in Rows field
  • Country & City in both "Columns" and "Values" fields
user_69082820
Related