Reply
Nsam1027
Frequent Visitor
Partially syndicated - Outbound

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

Syndicated - Outbound

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
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

10 REPLIES 10
Ashish_Mathur
Super User
Super User

Syndicated - Outbound

Hi,

Share some data and show the expected result.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Syndicated - Outbound

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.

IMG_4079.jpeg

IMG_4080.jpeg

Syndicated - Outbound

Sorry corrected required visual:

IMG_4082.jpeg

Syndicated - Outbound

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
https://www.linkedin.com/in/excelenthusiasts/

Syndicated - Outbound

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. 

Syndicated - Outbound

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


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Syndicated - Outbound

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

Syndicated - Outbound

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

Syndicated - Outbound

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

Syndicated - Outbound

Tooltip is not available for Table/matrix visuals.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)