Percent of Total by Day - (NOT % of Grand Total)

[irnm8dn]

I am trying to calculate the % of Total by Day.

In the screen capture below, imagine that I have 3 types of fruit.  Apples, Oranges, and Lemons.  I am trying to figure out how to calculate the percentage of sales for a specific day.

For instance, when you look at the left-most column I would like to label this as:

Lemons (Red) 60%

Oranges (Black) 8%

Apples (Blue) 32%

I only expect to show the values.

Thanks in advance.

[v-ljerr-msft]

Hi @irnm8dn,

Could you post your table structures with some sample/mock data, and the expected against it? So that we can better assist on this issue. It's better to share a sample pbix file. You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.

Regards

[irnm8dn]

@v-ljerr-msft

I have included a sample dataset and a ,pbix file. link

As you can see, my axis is using a date hierarchy.  I want to show the percentage of units sold based on Year, Month, Day so that I can at any specific time how much of my sales during that time period are made up of which fruit.

I have also included some notes within the .pbix in the text box.

Thank you.

[v-ljerr-msft · Accepted solution]

Hi @irnm8dn,

According to your description above, you want to show percentage(not percentage of grand total) as label on stacked column chart like below, but not like the 100% stacked column chart, right?

Currently, there is no option to show percentage(not percentage of grand total) as label on stacked column chart. You can add it as an idea on Power BI Ideas forum to improve Power BI on this feature.

An alternative solution is creating a new measure to calculate the percentage, and then show it as tooltips on the chart. 

Measure = 
DIVIDE (
    SUM ( 'Fruit Sample Data Set'[ Units Sold ] ),
    CALCULATE (
        SUM ( 'Fruit Sample Data Set'[ Units Sold ] ),
        ALL ( 'Fruit Sample Data Set'[Fruit] )
    )
)

Regard

[nwilliams]

THANK YOU @v-ljerr-msft !!! This DAX is exactly what I've been searching the internet for. Very much appreciated!

[aznaik]

Proposed solution doesn't works for me. I still get the % of Grand Total as a result