100% clustered chart

[jcastr02]

How can I get a 100% clusterd chart.  I'd like the same data on the left to be look like on the right.  However, I'd like for it not to be % of grand total, should be   numbers of what we see on left (essentially each cluster should equal 100%).

[jcastr02]

@v-jayw-msft    Hi Jay, this is how I have it currently.  I'd like it to be in your sample where both Bars for A - total 100%,  both bars for B total 100%, and both bars for C total 100%.....  VS. All bars totalling 100%

[v-jayw-msft]

Hi @jcastr02 ,

Modify the measure as below.

Measure = CALCULATE(SUM('Table'[value]),ALLEXCEPT('Table','Table'[ID],'Table'[type]))/CALCULATE(SUM('Table'[value]),ALLEXCEPT('Table','Table'[ID]))

If i misunderstood your meaning, please show your expected out put to us.

Best Regards,

Jay

Community Support Team _ Jay Wang

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

[jcastr02]

@v-jayw-msft     I don't necessarily have a "value" column, I just have a column with responses Yes, No, Not applicable.  I tried to create a custom column with the value of "1" for each of the responses.  I did this measure, but continues to have errors, any help is appreciated.  

[jcastr02]

@v-jayw-msft here is a sample of my data

[v-jayw-msft · Accepted solution]

Hi @jcastr02 ,

If i understand you correctly, you can use COUNT() function. Please refer to the below measure.

Measure 3 = CALCULATE(COUNT('Table'[Column2]),ALLEXCEPT('Table','Table'[Column1],'Table'[Column2]))/CALCULATE(COUNT('Table'[Column2]),ALLEXCEPT('Table','Table'[Column2]))

Result would be shown as below.

 

Best Regards,

Jay

Community Support Team _ Jay Wang

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

[v-jayw-msft]

Hi @jcastr02 ,

You might need a Clustered bar chart instead.

And please check the formula below.

Measure = CALCULATE(SUM('Table'[value]),ALLEXCEPT('Table','Table'[id],'Table'[type]))/CALCULATE(SUM('Table'[value]),ALL('Table'))

 Here's my sample data and out put.

If i misunderstand you meaning, please share some sample data and expected result to us.

Best Regards,

Jay

Community Support Team _ Jay Wang

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

[Greg_Deckler]

Sample data would be great. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[Greg_Deckler]

One thought, you might try clicking the drop down on a column in the Values area and choose Show as | Percent of Total or Percent of Grand Total. I know you can do that in Tables and Matrices.

[jcastr02]

@Greg_Deckler Hi there, this is how I have it currently.  What I'm trying to do is.. I'd like both bars for "yes" to equal 100%, both bars for "no" equal 100%, and both bars for not applicable to equal 100%