Color formatting

[matka123499]

Hello,

So I have power BI overview of different clients and their products and prices. I put all these into line graph however now I am getting mix of products prices of all clients (if not filtered to just one client) and each price has different color.

I would like to clean up the graph and just have one color chosen for one client and for all of their product prices. So if I filter out Client 1 and Client 2 I will see bunch of product prices on graph but only green and blue color lines depending under wich client the product is

Can you please help me?

[Anonymous]

Hi @matka123499 ,

@rubayatyasmin Thanks for your concern about this case!

After my test, you can try to build the Line graph like this:

X-axis is product, Y-axis is price and Legend is client. Then we can see that each line is a different color, each color represents a client, and the product under each client is in one color.
If I filter out Client 1 and Client 2:

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

[matka123499]

thank you but this will only work if I sum the product prices. I cannot have more individual lines for products for one client the same color?

[Anonymous]

Hi @matka123499 ,

Sorry but can you show me you sample data and your expected results?
I can't understand what your needs are.

Best Regards,
Dino Tao

[rubayatyasmin]

@matka123499 

I suggest you use bar chart for this Viz. Line chart seems less suitable in this scenario. Place Product col in the Y axis, and price in X axis. Client in the legend. 

Now go to formats pane and select bar option to choose unique colour for each client.