Deneb Clustered Stacked Bar chart to match Excel

Deneb Showcase
1

Dear Team,

Thank you for your always support. I am trying to create a clustered bar chart as on the picture and in the PBI attachment and I almost achieved this using Deneb. However am having a problem with order/sort for the base measure. Where the small group values should be on top of the bars for positive numbers and on the bottom of the bars for negative numbers as on screenshot. Could you please advise if it is possible in Deneb?

Thank you in advance

stacked bar chart measure order
stacked bar chart measure order800×533 16.2 KB

Stacked bar chart measure order.pbix (1.4 MB)

2

Hi @vazik. Deneb can do just about anything … here’s my first try. If this is what you’re looking for, then you just have to revise the order block.

eDNA Forum - Deneb Stacked Column Chart Sort Order
eDNA Forum - Deneb Stacked Column Chart Sort Order1787×1565 359 KB

Hope this helps.
Greg
eDNA Forum - Deneb Stacked Column Chart Sort Order.pbix (1.4 MB)

3

Thank you very much for the reply. I think i tried this and it is not working for negative numbers (yellow for example should be after red one). I am attaching also orig excel screenshot.
orig excel
1

Thank you!

4

Hi @vazik. I must be misunderstanding your issue. Please prepare an Excel table with the rows in exactly the order you want them displayed; perhaps that will help identify the issue.
Greg

1 Like
5

i got it now Greg, thank you for advise! Managed to fix it like below:

Topic can be closed.

Appreciated

fix
fix564×614 20.2 KB

eDNA Forum - Deneb Stacked Column Chart Sort Order fixed.pbix (1.4 MB)