Forum Discussion

Sara_Hornstein's avatar
Sara_Hornstein
Frequent Visitor
9 years ago

organizing tabel

 

 

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

 

Need Help

1 Reply

  • v-caliao-msft's avatar
    v-caliao-msft
    Microsoft Employee
    9 years ago

    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