Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
Expand all | Collapse all

Need to create a table, matrix or multi-row card.

  • 1.  Need to create a table, matrix or multi-row card.

    Posted 15 days ago
    The data source has 2 columns, the first has 8-10 entities and the second has 3 different activities. Here is an example:
    Name Activity
    April A
    August A
    December C
    February B
    February C
    July B
    April C
    January C
    June A
    March A
    There will be a total of approximately 200 rows and I need to display the count of each activity for each name so that it displays as it does in the example:

    Name Activities
    January A: 7
    B: 5
    C: 5
    February A: 6
    B: 6
    C: 5
    March A: 7
    B: 5
    C: 6
    April A: 5
    B: 6
    C: 6

    Is there a way to build a table, matrix or multi-row card to achieve the above display?

    ------------------------------
    Kevin Joos
    Intelligence Analyst
    Woodbridge VA
    ------------------------------


  • 2.  RE: Need to create a table, matrix or multi-row card.

    Posted 14 days ago
    Hello Kevin,

    If you add a measure to count the rows in the data table, you can easily do this in a table visual.

    Measure:
    Total Activity = COUNTROWS('Table')



    ------------------------------
    Jarom Buys
    ------------------------------



  • 3.  RE: Need to create a table, matrix or multi-row card.

    Posted 14 days ago
    Thank you Jarom. I was able to accomplish that display by placing the activity under the value twice with the first having 'Don't Summarize' checked and the second having 'Count" checked. What I wanted to show was each name value only showing once with the activity and activity totals showing as they do above, so using the above example the first and third April would not display and only the middle one would. I don't think that is possible, so once the visualizations are finished I will place it in PowerPoint and hide the unwanted values that way.

    ------------------------------
    Kevin Joos
    Intelligence Analyst
    Woodbridge VA
    ------------------------------



  • 4.  RE: Need to create a table, matrix or multi-row card.

    Top Contributor
    Posted 13 days ago
    Try using a matrix instead of a table.

    ------------------------------
    Vishesh Jain
    MCSA Power BI and Excel
    Emerald Award Dynamic Communities 2019
    Owner
    VR Construction
    ------------------------------



  • 5.  RE: Need to create a table, matrix or multi-row card.

    Posted 13 days ago
    Hi Kevin,

    @Vishesh Jain is correct. You can use a Matrix visual to do something similar. Use Name and Activity in the row ​s and Total Activity in the Values.

    Then use the forked down arrow to expand the hagiarchy, and use the visual formatting tools to change the layout. Under Row Headers you can toggle off the Stepped layout and change the Outline to None. Under Subtotals you can toggle off the Row subtotals.

    I couldn't find a way to center the row headers vertically.



    ------------------------------
    Jarom Buys
    ------------------------------



  • 6.  RE: Need to create a table, matrix or multi-row card.

    Posted 13 days ago
    Thank you Vishesh and Jarom, that worked great. I couldn't find a way to center the row headers either, but it looks great. Now I just need to get the zeros to show and I'll have completed my first project.

    Thanks again

    ------------------------------
    Kevin Joos
    Intelligence Analyst
    Woodbridge VA
    ------------------------------