Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Multiple Columns One Chart with Different Results

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 

 

Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    6 years ago

    hi, Anonymous 

    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

2 Replies

  • kentyler's avatar
    kentyler
    Solution Sage
    6 years ago

    unpivot

    fruit | value

    pear true

    pear true

    apple false

    apple true

  • v-lili6-msft's avatar
    v-lili6-msft
    Community Support
    6 years ago

    hi, Anonymous 

    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