Multiple Columns One Chart with Different Results

[PeterDonohue]

I could not figure out how to name this subject 🙂 but looking for some assistance.

I have 6 columns (all binary TRUE/FALSE)
Each one has a differrent heading i.e. pears / apples / peaches / bananas 
So....
Pear   |    Apple   |    Peaches  |  Bananas
True   |    False    |    True        |   False
False  |    True     |    False       |    True

Ideally I'd love to be able to display this on 1 column Chart with each column being a type of fruit and the size being the COUNT of the instances of TRUE

I'm just drawing a blank 🙂

Thanks 

[v-lili6-msft · Accepted solution]

hi, @PeterDonohue 

You could also try this way:

Create 6 measure as below:

COUNT Apple = CALCULATE(COUNTA('Table'[Apple]),'Table'[Apple]=TRUE())

COUNT Peaches = CALCULATE(COUNTA('Table'[Peaches]),'Table'[Peaches]=TRUE())

COUNT Pear = CALCULATE(COUNTA('Table'[Pear]),'Table'[Pear]=TRUE())

and so on.

Then create a clustered bar char by these measure.

and here is a simple sample pbix file, please try it.

Regards,

Lin

[kentyler]

unpivot

fruit | value

pear true

pear true

apple false

apple true