Forum Discussion

Nsam1027's avatar
Nsam1027
Frequent Visitor
2 years ago
Solved

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 emplo...
General Comment
  • Ashish_Mathur's avatar
    Ashish_Mathur
    2 years ago

    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's avatar
Nsam1027
Frequent Visitor
2 years ago

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's avatar
Nsam1027
Frequent Visitor
2 years ago

Sorry corrected required visual:

 

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    2 years ago

    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's avatar
      Nsam1027
      Frequent Visitor
      2 years ago

      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's avatar
        Ashish_Mathur
        Super User
        2 years ago

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