Matrix visual

[Nsam1027]

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? 

[Ashish_Mathur]

Hi,

Share some data and show the expected result.

[Nsam1027]

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.

 

 

[Nsam1027]

Sorry corrected required visual:

 

[Ashish_Mathur · Accepted solution]

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.

[Nsam1027]

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. 

[Ashish_Mathur]

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

[Nsam1027]

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

[Nsam1027]

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

[Nsam1027]

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

[Ashish_Mathur]

Tooltip is not available for Table/matrix visuals.