cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
abisaileon11 Regular Visitor
Regular Visitor

Show the percentage of a pie chart in a card

Hello,
I'm making a report of sales and I use a pie chart to show what product is most sold. Also I put a card to show the number of units sold and I wanna put another one to show the percentage of the product I selected. 

 

Untitled.jpgUntitledd.jpg

 

For example, in the image above I selected a product with 27.53% of total sales but in the card still appear 100%.
Hope you can help me. 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User
Super User

Re: Show the percentage of a pie chart in a card

You will need to create a measure for your card along the lines of:

 

Measure =
SUM('Table'[Sales]) / SUMX(ALL('Sales'),[Sales])

Set it to be a %.


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


1 REPLY 1
Highlighted
Super User
Super User

Re: Show the percentage of a pie chart in a card

You will need to create a measure for your card along the lines of:

 

Measure =
SUM('Table'[Sales]) / SUMX(ALL('Sales'),[Sales])

Set it to be a %.


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!