Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

Calculate percentage of each type per year

I want to create a table in PowerBi that shows the percentage of call backs, purchases, cancels etc. based on data from my SharePoint list. 

 

In my SharePoint list, each line item has a DATE and a TYPE column. I want to know the percentage of each TYPE per year. 

 

How would I do this? 

 

 

Type202020212022
Call back%%%
Purchase%%%
Cancel%%%
Inquiry%%%
Trade%%%
Sell%%%
1 ACCEPTED SOLUTION
Bifinity_75
Solution Sage
Solution Sage

Hi @Anonymous , First insert a Matrix, and insert column "Type" in rows of the Matrix, insert "Date" in columns of the Matrix, and insert "Type" in values of Matrix:

Bifinity_75_0-1669138415120.png

 

After, In values select "Count" and % of total column, like the image:

Bifinity_75_1-1669138550774.png

 

Best regards

 

 

 

View solution in original post

1 REPLY 1
Bifinity_75
Solution Sage
Solution Sage

Hi @Anonymous , First insert a Matrix, and insert column "Type" in rows of the Matrix, insert "Date" in columns of the Matrix, and insert "Type" in values of Matrix:

Bifinity_75_0-1669138415120.png

 

After, In values select "Count" and % of total column, like the image:

Bifinity_75_1-1669138550774.png

 

Best regards

 

 

 

Helpful resources

Announcements
PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.