Forum Discussion
Combining two visuals in single visual
Hi,
I have two stacked column bar charts as the following, the left one is Actual and the right one is Target. I wanted to combine them in a single visual and show each actual column adjacent to its Target column, how I can do it?
Hi Anonymous ,
Sorry for this questions but to help you in the best way we need to understand the result and data you provide, to what I can see from the print the csutom column on the Actuals matches the Team on the target correct?
Is this the X-Axis on your chart?
If yes what composes your categories withing each bar?
Regards,
MFelix
And what are the values you are counting/sum on your values?
Anonymous ,
You may select Unpivot Columns in Query Editor.
14 Replies
v-chuncz-msft No, I don't want to use drill down since the business users are not comfortable with this option.
Is there any visual like Excel for combinig stacked column charts?
Please reply
Hi Anonymous ,
Believe that the best option is as v-chuncz-msft refered to do a drill down option making the actuals and Budget the last drill down row, then you should place the visual on the lowest level and that would give target next to actuals.
Assuming that you are making this for users to use on the web service if you then disable the drill down buttons then users wouldn't even realized they are looking at a drill down chart.
As you can see below on the web service the drill down is not visible, on the desktop the option is visible because it's consider editing mode so you will always see it.
Desktop version:
Web version
See attach the pbix file with the example.
Regards,
MFelix
you may try to use some custom visuals like bullet chart and other available visuals on the marketplace
mussaendaThanks, but what is the relationship between bullet chart and combined stacked bar chart really?! I need to have two stacked bar chart in one visual which is my problem now!
I was just suggesting since bullet chart has target fields. It's up to you if you will try t or not. If it didn't help you, then I apologise. Good luck on combining two stacked bar charts in one visual! Please do let me know if you have found an answer, I would be happy to use it too.
