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 / bana...
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

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