Forum Discussion
Combining two visuals in single visual
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.
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
MFelixHow I can open your file in the older version of pbix? Since our company policy only let use have the version for Sep2018!
MFelixThe problem I have is that the Actual and Target visuals are not connected because they come from two naturally different tables(main difference is there is no common unique column between the two tables to let me join them or concatinate them)!
what should I do in this case? How to change my model to connect them?