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

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

Nsam1027's avatar
Nsam1027
Frequent Visitor
2 years ago

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

    Tooltip is not available for Table/matrix visuals.