Power BI Exchange

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
------------------------------

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
------------------------------

Original Message:
Sent: Feb 21, 2021 03:50 PM
From: Kevin Joos
Subject: Need to create a table, matrix or multi-row card.

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
------------------------------

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
------------------------------

Original Message:
Sent: Feb 22, 2021 10:22 AM
From: Jarom Buys
Subject: Need to create a table, matrix or multi-row card.

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

Original Message:
Sent: Feb 21, 2021 03:50 PM
From: Kevin Joos
Subject: Need to create a table, matrix or multi-row card.

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
------------------------------

Try using a matrix instead of a table.

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

Original Message:
Sent: Feb 22, 2021 03:49 PM
From: Kevin Joos
Subject: Need to create a table, matrix or multi-row card.

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

Original Message:
Sent: Feb 22, 2021 10:22 AM
From: Jarom Buys
Subject: Need to create a table, matrix or multi-row card.

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

Original Message:
Sent: Feb 21, 2021 03:50 PM
From: Kevin Joos
Subject: Need to create a table, matrix or multi-row card.

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
------------------------------

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
------------------------------

Original Message:
Sent: Feb 22, 2021 03:49 PM
From: Kevin Joos
Subject: Need to create a table, matrix or multi-row card.

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

Original Message:
Sent: Feb 22, 2021 10:22 AM
From: Jarom Buys
Subject: Need to create a table, matrix or multi-row card.

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

Original Message:
Sent: Feb 21, 2021 03:50 PM
From: Kevin Joos
Subject: Need to create a table, matrix or multi-row card.

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
------------------------------

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
------------------------------

Original Message:
Sent: Feb 23, 2021 08:40 AM
From: Jarom Buys
Subject: Need to create a table, matrix or multi-row card.

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

Original Message:
Sent: Feb 22, 2021 03:49 PM
From: Kevin Joos
Subject: Need to create a table, matrix or multi-row card.

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

Original Message:
Sent: Feb 22, 2021 10:22 AM
From: Jarom Buys
Subject: Need to create a table, matrix or multi-row card.

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

Original Message:
Sent: Feb 21, 2021 03:50 PM
From: Kevin Joos
Subject: Need to create a table, matrix or multi-row card.

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
------------------------------