Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

PowerBI matrix visual show frequency

Hi,

 

I am trying to make a PBI matrix that looks like the screenshot below - with frequency indicating how many entries there are for the particular staff id.

 

I am able to put staff_id and description as 'rows' , and amount as 'values' for the matrix, but I am truggling to get the frequency showing in the second column. What I have so far are something looks like below:

Thanks a lot!

 

 

1 Reply

  • Anonymous , if the frequency is a measure you can not.

     

    You can explore segmentation of frequency, then it can be used as in row

    Dynamic segmentation -Measure to Dimension conversion: https://youtu.be/gzY40NWJpWQ