Forum Discussion
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 presentation possible with PowerBI?
Thanks in advance
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
2 Replies
If you have the proper data, this kind of visual is possible.
There's a 'Table' visual included in Power BI
GreetingsHi 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
