Differentiate similar values from different id in bar chart

[Anonymous]

Hello Folks,

I have a column where there are similar values for different ids. For Example, Please have a look at the table below:

Client	Client_Id	User_id	Name	Data
Samsung	100	01	John Smith	1000
Apple	101	02	John Smith	1200
Nokia	102	03	Katie Bond	800
Blackberry	103	04	Kattie Bond	900

Now, when I want to visualise the count of data for each user on the bar chart, what happens is John Smith's & Kattie bond's data gets clustered in single bar chart with different colors, as I am using client Name as legend in the visualisation. 

What I want to see is, separate bars for each individual user in the bar chart.

Please Help!

[v-rzhou-msft · Accepted solution]

Hi @Anonymous 

I think your visual is as below. When you add Client name into legend, Power BI will divide values with Client group by different colors.

If you want the bar show same color for each user, you can change data colors in visual format. By this way, you need to make sure that there is no same clients in for differents users. For example: John has Apple and Samsung, so you can change them to blue. But if Katie has Apple or Samsung as well, it is not a good idea.

Or you can remove the client Name from legend in the visualisation and add user name into legend.

Power BI doesn't support you to use conditional formatting if you add columns in legend.

Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

[amitchandak]

@Anonymous , If you have both of them in axis you can use color measure for the user.

Refer the power bi part, how to use conditional formatting in such a case -Bar/Clustered Bar: https://youtu.be/2P5BBRN853c