Show multiple chart bars of a same column in PBI Desktop

[hamzahad91]

I would like to compare different values of a same column.

I added 2 times the same column

In my visual I have only one value ( one type of bars ) .

Also, in filter I can't choose other values that I have in the first filter .

Any way to do it ? Should I absolutely make a mesures?

[fhill]

Can you post some fake sample data, and an idea of what you are trying to make it look like?

FOrrest

[hamzahad91]

For exemple I have this table

ColA                    Col B

-------------------------------

  cat                |    2

  dog              |    5

  bird              |    8

  Justin bieber  |    2

I would have one and only one visual of multple bars of every category in ColA

For that I should add ColA four times but PBI Desktop consider only the first col added in Values field and show me one category.

[v-huizhn-msft]

Hi @hamzahad91,

I am still confusing your requirement. Based on my understanding, you create a clustered bar chart.Either add the ColA as Axis or Legend, you can compare the different values for each category in ColA. Or the sample table just part of your resource table? Could you please share more details for further analysis?

ColA as AxisColA as Legend
Thanks,
Angelia

[Greg_Deckler]

Not entirely sure what you are trying to do, but measures might get you there:

Measure1 = CALCULATE(COUNT(Table[Column]),FILTER(Table,[Column]="Value1"))

Measure1 = CALCULATE(COUNT(Table[Column]),FILTER(Table,[Column]="Value2"))

That being said, perhaps put the column in the axis or legend area?