to split bars in clustered column chart

[Anonymous]

HI!

I have one problem when I use clustered column chart ( 

I hve two measures ( sales>0 and sales<0) , and each of then depend on date and typeID.

I need to connect splitting by date and by tapeID, which are realized in EXCEL based on pivot table. 

Could you help me, please, how I can combine it in one clustered column chart in PowerBI?

I can made two charts using 2 dementions and 1 measure, but If I choose 2 measures, I cannot use draging data fields ( in legend of this chart)

I know that I can use tool-tips for detailization each of bars when hovering the mouse, but it's not convenient because I need to see all datailizations on one visualization.

If you know the best way , let me know, please

BR,

terpilka

[v-yuta-msft · Accepted solution]

Hi terpilka,

To achieve your requirement, you should turn measure s< and s> into original columns, you can click query editor -> add column-> custom column to create two columns. Then click transform-> unpivot columns, the result is like below:

 

Regards,

Jimmy Tao

[Anonymous]

Amazing!
Thank you a lot! 

BR, 
terpilka