Forum Discussion

hockeymom64's avatar
hockeymom64
New Member
8 years ago
Solved

Need help with a table visual

Hi I am still a newbie with PowerBi and I need some help with how to build a report with a table visual. I am wondering if the following presentation is possible   I   Is this kind of visual ...
  • Anonymous's avatar
    Anonymous
    8 years ago

    Hi hockeymom64,

     

    Current table visual can't achieve your requirement, I'd like to suggest you to use matrix visual if each rows has similar status value.(normally matrix only support show the summary value)

     

    Steps:

    1. Drag 'Date','Event Name','Event description','Location','Participant' to Rows fields, 'Status'  to value fields with summary mode 'first'/'last'.

    2. Turn off 'Stepped Layout'. (Format tab(Brush icon) -> Row headers)
    3. Turn off 'Row Subtotals' feature. (Format tab(Brush icon) -> Subtotal)

     

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi hockeymom64,

 

Current table visual can't achieve your requirement, I'd like to suggest you to use matrix visual if each rows has similar status value.(normally matrix only support show the summary value)

 

Steps:

1. Drag 'Date','Event Name','Event description','Location','Participant' to Rows fields, 'Status'  to value fields with summary mode 'first'/'last'.

2. Turn off 'Stepped Layout'. (Format tab(Brush icon) -> Row headers)
3. Turn off 'Row Subtotals' feature. (Format tab(Brush icon) -> Subtotal)

 

Regards,

Xiaoxin Sheng