- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi,
Share some data and show the expected result.
Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Sorry corrected required visual:
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Sorry I couldn't find the option to switch the rows in format visual. Can u please eloborate?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Able to find it.. Thankyou so much for your prompt response. Appreciate it!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Tooltip is not available for Table/matrix visuals.
Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
12-09-2024 09:53 AM | |||
11-21-2024 01:13 AM | |||
11-28-2024 10:35 AM | |||
09-18-2024 10:15 AM | |||
11-27-2024 05:19 AM |
User | Count |
---|---|
140 | |
110 | |
81 | |
61 | |
46 |