Several column charts next to each other possible?

[rob7one]

Hi guys,

i would like to visualize several column charts next to each other to compare the supplier performance with different locations/plants. Currently i have one column chart for each location which shows me the top 5 suppliers by amount of defective parts. Thats basic.

I need to show now an overview about all locations in comparison to each of them in one column chart. That means i would like to create a visual with an Y-axis (amount of defects) and an X-axis with top 5 suppliers for each plant (not top 5 for all plants) like this:

Is it possible and could someone give me support here a bit?

[v-yangliu-msft]

Hi  @rob7one ,

I created some data:

Here are the steps you can follow：

1. Create measure.

Rank =
RANKX(
    FILTER(ALL('Table'),
    'Table'[Plant]=MAX('Table'[Plant])),CALCULATE(SUM('Table'[Value])),,DESC)

Flag =
IF(
    [Rank]<=5,1,0)

2. Place [Flag]in Filters, set is=1, apply filter.

3. Result:

Best Regards,

Liu Yang

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

[rob7one]

Hi @v-yangliu-msft ,

big thanks for your support. For your created example it seems to work fine. I have reproduced it for my data and it shows me this as result:

For some reason it didnt display rank 3. When i choose an other plant by slicer it shows only rank 1,2,2,2,3 (with different total defects value). dont know why it is not consistent for my data.

I have find out a little different measure than yours, that seems to work i guess:

A_rank top5 = RANKX(ALLEXCEPT(A_Notify_List,A_Notify_List[Plant for material /plant number]),

CALCULATE(SUMX(A_Notify_List,A_Notify_List[Defective (external)]),

ALLEXCEPT(A_Notify_List, A_Notify_List[Plant for material /plant number],A_Notify_List[Name 1 /vendor name])),,DESC,Dense)

That is working (i hope because just checked with table till now), but there are two steps more to go for me to complete this task:

1. When i choose a specific month to filter the table or visual for example only for october 2022 data it shows me the top suppliers by defects (for october 2022) but it does not show me the new rank for ocotber, only the old one for all months. i think i have to add something to count in the month (or date) to the measure. 

Without date filter:

With date filter october 2022

2. i need to display on y-axis (in the collumn chart) the number of total defects, not the rank.

Do you have an idea?

[Idrissshatila]

Hello @rob7one ,

Yes try the Clustered Column Chart were you add the suppliers as legend.

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin

[rob7one]

Hello @Idrissshatila ,

thanks for your reply. I already tried this out. This is my result:

It displays now top 5 suppliers worldwide across all plants. I would like to show the top 5 suppliers in every plant seperatly to compare in this visual all the top 5's between the plants, like in the image of my first post. I hope you got me.

[Idrissshatila]

Hello @rob7one,

yes got you, try this article and see if this is what you're looking for https://powerbidocs.com/2020/01/21/power-bi-top-n-filters/

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin

[rob7one]

Hello again @Idrissshatila ,

the image of my second post is exactly the result of what is described in your link. it shows the top 5 (by regular filter) across all plants. the very last step is now:

how i can show the top 5 for every plant seperatly. in other words i think i need to filter every plants top 5 for it's own, right? if yes how? 🙂

thank you anyway for the support till here btw, thats really nice.