Forum Discussion
to split bars in clustered column chart
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
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
2 Replies
v-yuta-msftCommunity Support
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