Forum Discussion
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...
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.
Sorry corrected required visual:
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.
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.
You are welcome. In the format seeting of that visual, turn on "Switch to Rows".
Sorry I couldn't find the option to switch the rows in format visual. Can u please eloborate?