100% of each value by legend

[jcastr02]

How can I get within each number on chart, it to be 100% in each one in both graphs?  Example - Under PR&A sessions, under Not applicable, the grey bar and black bar should equal 100%......(vs. 3-7%).  Right now I have as % of Grand total, but need % of Grand total within each legend type....

[v-yuta-msft]

@jcastr02 ,

Do you mean the percentage total in visual 'PR&A Sessions' should be 100%. If so, please check if all the values has been contained in your measure. Have you dragged the proper column to the X-axis?

Regards,

Jimmy Tao

[jcastr02]

yes, each 'cluster' should equal 100%    so both bars for Not applicable should equal 100%, both bars for No should equal 100% and both bars for yes should equal 100%  @v-yuta-msft 

[v-yuta-msft]

@jcastr02 ,

In general, you should create measure maunally because the "%GT of count" will just calculate percentage of each part.

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[jcastr02]

@v-yuta-msft   Thank you.  Would you happen to know how to write the DAX for this?

[Anonymous]

did you ever find a way to do this? i know its been three years since but just checking

[jcastr02]

@Anonymous Unfortunately did not 😞

[v-yuta-msft]

@jcastr02 ,

I'm afraid I'm not able to do further analysis without the sample data. Could you please share some sample data and give the expected result?

Regards,

Jimmy Tao

[Greg_Deckler]

Not 100% what you are going for. 100% stacked column?

[jcastr02]

@Greg_Deckler   Essentially each cluster should equal 100%, vs. all bars equally 100%