cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

## Matrix visual

In power Bi,
In Matrix visual I need to show The column headers A, B, C, D (values present in column "F") and the rows will display the count of unique employee IDs and sum of FTE for distinct employee IDs under each column header. How do I achieve this?

1 ACCEPTED SOLUTION
Super User

Hi,

Drag column B to the column well of the matrix visual.  Write these measures

Measure 1 = countrows(Data)

Measure 2 = sum(Data[Amount])

Hope this helps.

Regards,
Ashish Mathur
http://www.ashishmathur.com
10 REPLIES 10
Super User

Hi,

Share some data and show the expected result.

Regards,
Ashish Mathur
http://www.ashishmathur.com
Frequent Visitor

Hi Ashish, please find the screenshots below.Let me know if you need further details..fyi- I have already created a new table with unique Emp Id with FTE and Frequency.But not able to visualize as shown in the required visual.

Frequent Visitor

Sorry corrected required visual:

Super User

Hi,

Drag column B to the column well of the matrix visual.  Write these measures

Measure 1 = countrows(Data)

Measure 2 = sum(Data[Amount])

Hope this helps.

Regards,
Ashish Mathur
http://www.ashishmathur.com
Frequent Visitor

Thankyou Ashish..It's working as expected, but the Matrix visual currently displays "B" and "C" values side by side. My requirement is to have "B" values in the first row and "C" values in the second row.

Super User

You are welcome.  In the format seeting of that visual, turn on "Switch to Rows".

Regards,
Ashish Mathur
http://www.ashishmathur.com
Frequent Visitor

Sorry I couldn't find the option to switch the rows in format visual. Can u please eloborate?

Frequent Visitor

Able to find it.. Thankyou so much for your prompt response. Appreciate it!

Frequent Visitor

Hi Ashish,  when I hover on the values in the visual.. how can I get percentage? I don't have option to add a filter in tooltip

Super User

Tooltip is not available for Table/matrix visuals.

Regards,
Ashish Mathur
http://www.ashishmathur.com