combo chart

[Anonymous]

Is there a way to create a combo chart with 2 lines + 2 vertical bars? I have two brands that I want to display the units and revenue by time periods. Now I can do the stack bar to show 2 brands (use brand as column series and units as column value). when I drag the revenue to the line value, it adds up the revunue for the two brands. Is there any way to show line for each brand?

thanks,

Wenchi Wang

[Anonymous]

Hi @Anonymous,

In your scenario, you would need to create two measures to calculate revenue value for each brand, then drag the two measures into Line Values of combo chart. You can check the example in the following screenshot.



Thanks,
Lydia Zhang

[WmRodriguezSr]

I have a measure that needs to be broken down by (say) 'Product Brand' on the line chart. I personally do not want to edit (or have access to editing) the PBIX file everytime a new product brand comes online; thus I need the line to be broken down by product brand. . . Any ideas?

[ElliotP]

@WmRodriguezSrI would interested in this solution as well.

[Anonymous]

Thanks you all for your reply. I forgot to mention that my data soruce is SSAS tabluar cube, which is not allowed to created measures on the fly. Hope we can do this in the future.

Wenchi Wang

[Anonymous]

Hi @Anonymous，

You are connecting live to SSAS cube in Power BI Desktop, right? If so, we are not able to create new measures. Some ideas about these issues have been submitted in the following link, please vote them up. In this case, you can consider to create another Line chart and drag brand field to Legend to work around this issue. Or you can connect to SSAS cube using import mode and create new measures, then drag them into combo chart.

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/12532173-ssas-get-data-multiple-data-sources
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/11685723-create-calculated-measures-on-top-of-a-live-ssas-c

Thanks,
Lydia Zhang

[BhaveshPatel]

Hi @Anonymous Wang,

You should separate your product brands in two columns to see each of them as individual. You can use Query Editor for that.