Forum Discussion

qwertzuiop's avatar
qwertzuiop
Advocate III
6 years ago
Solved

How to edit bar chart?

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

Need Help
  • v-xicai's avatar
    v-xicai
    6 years ago

    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.

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi qwertzuiop 

     

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

     

  • v-xicai's avatar
    v-xicai
    Community Support
    6 years ago

    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.