cancel
Showing results for
Did you mean:
Highlighted
Frequent Visitor

## Displaying Matrix visual values in multiple columns

I have student data for 10 schools. I am trying to calculate and display in a matrix visual the student strength by level of education they are in.

I have data as below:

School Name        Class            Strength

I want to see the display the data in the matrix as follows

School Name      FS (Combined 9 and 10)       JS (Combined 11 and 12)

AAA

BBB

CCC

I know this might be too easy. But rookie here. Thanks.

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team

## Re: Displaying Matrix visual values in multiple columns

@gul ,

Firstly, create an additional column "Category" using DAX below:

`Category = IF('Table'[Class] = "Grade 9" || 'Table'[Class] = "Grade 10", "FS", "JS")`

Then create a matrix visual, drag Category to Columns, School Name to Rows and Strength to Values.

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

4 REPLIES 4
Community Support Team

## Re: Displaying Matrix visual values in multiple columns

@gul ,

What does "Combined 9 and 10" and "Combined 11 and 12" mean? Could you share more details about the logic?

Regards,

Jimmy Tao

Frequent Visitor

## Re: Displaying Matrix visual values in multiple columns

Combined means to add the strength of both classes. So basically, in our system, we have two categories

Category A (Grade 9 and 10)

Category B (Grade 11 and 12)

Frequent Visitor

## Re: Displaying Matrix visual values in multiple columns

anyone?

Community Support Team

## Re: Displaying Matrix visual values in multiple columns

@gul ,

Firstly, create an additional column "Category" using DAX below:

`Category = IF('Table'[Class] = "Grade 9" || 'Table'[Class] = "Grade 10", "FS", "JS")`

Then create a matrix visual, drag Category to Columns, School Name to Rows and Strength to Values.

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Announcements

#### Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

#### Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

#### Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

#### Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!