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.
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?
Able to find it.. Thankyou so much for your prompt response. Appreciate it!
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
Tooltip is not available for Table/matrix visuals.