organizing tabel

[Sara_Hornstein]

Hi!

I am working on this tabel and I want to create a report where it shows the entityld, age and gender everytime I choose a group, like the image under this one, but i am having problems because it doesn't show the age or gender when I have the group field chosen, I think it´s because I should have the information I need in each row and not alternade in the value....if you know what I mean....is there any way I can solve this?

Many thanks

Sara

[v-caliao-msft]

@Sara_Hornstein,

Based on your screenshot, it seems that you data is chaotically stored. You'd better to reshap your data model to let it looks like:

ID

EntityID

KeyGroup

DateOfBirth

Age

Gender

Company

Group

Or your could use a matrix visual to display your data, add Value field to Column.

Regards,

Charlie Liao