How to edit bar chart?

[qwertzuiop]

Hello PowerBI-Community

As you can see below, I have created a bar chart by displaying push messages in a certain period of time. The push messages can be assigned to a customer (here customer = ?).

I would like to create a second bar chart, which ONLY considers the respective customer (in this case customer=?)

In this case, the second bar diagramm would show only the filled blue area.

This allows me to better visually see how a customer's push messages differ per day.

How can I do that? I have the attributes date, number of push messages & customer number.

I am incredibly grateful for your help.

Have a nice day

Cheers

qwertzuiop

[v-xicai · Accepted solution]

Hi @qwertzuiop ,

You may create measure like DAX below, then put the measure into value box of chart visual.

Count push messages =CALCULATE(COUNT(Table1[push messages]),ALLSELECTED(Table1[customer number]))

Best Regards,

Amy

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

[Anonymous]

Hi @qwertzuiop 

What about if you create a measure that sustract the push messages from the customer from the sum of all push messages?