Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Can you post some fake sample data, and an idea of what you are trying to make it look like?
FOrrest
Proud to give back to the community!
Thank You!
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.
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?
Thanks,
Angelia
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
96 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |