Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Kevin Joos]

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

[Jarom Buys]

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

[Kevin Joos]

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

[Vishesh Jain]

Try using a matrix instead of a table.

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

[Jarom Buys]

Hi Kevin,

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

[Kevin Joos]

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