cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
hamzahad91 Regular Visitor
Regular Visitor

Show multiple chart bars of a same column in PBI Desktop

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

I added 2 times the same column

empile.PNG

 

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?

 

 

4 REPLIES 4
Super User
Super User

Re: Show multiple chart bars of a same column in PBI Desktop

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?


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


fhill Established Member
Established Member

Re: Show multiple chart bars of a same column in PBI Desktop

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

 

FOrrest

hamzahad91 Regular Visitor
Regular Visitor

Re: Show multiple chart bars of a same column in PBI Desktop

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 Super Contributor
Super Contributor

Re: Show multiple chart bars of a same column in PBI Desktop

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?

2.PNGColA as Axis1.PNGColA as Legend
Thanks,
Angelia