Forum Discussion

Mallikarjun_P's avatar
Mallikarjun_P
New Member
3 years ago
Solved

Communications dashboard for Department

Hi, I am trying to build a communications dashboard for department where I collect topics under various categories for every month. My table looks something like this

 table

I would like to display dashboard in a 2*2 matrix format

rows as categories and month wise columns as below

Dashboard

I used matrix object but it is showing either the first or last topic only per month. How can I show all topics per month in Power BI

General Comment
Need Help
Show and Tell
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Mallikarjun_P ,

     

    I suggest you to create a measure by below code.

    Combine =
VAR _AddCombine =
    ADDCOLUMNS ( 'Table', "Combine", COMBINEVALUES ( " : ", [Topic], [Speaker] ) )
VAR _CONCATENATE =
    CONCATENATEX ( _AddCombine, [Combine], "
" )
RETURN
    _CONCATENATE

    Result is as below.

     

    Best Regards,
    Rico Zhou

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Mallikarjun_P ,

     

    I suggest you to create a measure by below code.

    Combine =
VAR _AddCombine =
    ADDCOLUMNS ( 'Table', "Combine", COMBINEVALUES ( " : ", [Topic], [Speaker] ) )
VAR _CONCATENATE =
    CONCATENATEX ( _AddCombine, [Combine], "
" )
RETURN
    _CONCATENATE

    Result is as below.

     

    Best Regards,
    Rico Zhou

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.