How to model this kind of combo chart

[Pbiuserr]

Hello,

I am trying to create a combo chart in which one filter will change value on column, the same field in the second filter (probably from other table) will change value on line. So [Category] from Table1 will change column value on chart, [Category] from Table2 will change line value on chart.

I have bunch of referential tables from which I'd need filters for the chart and a measure ready to fill both column and line value

[v-chenwuz-msft]

Hi @Pbiuserr ,

It might be a good option to inactivate the relationships between fact tables and data tables. Use use relationship() to activate the relationship between these tables in the measure. Or use ALL() to remove the filters from another dim table.

The main purpose of these methods is to allow the chart to get the full context of the fact table.

If you need more help, please share some example data and expect result.

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Pbiuserr , Not very clear, do you need something like

Compare Categorical Data Using Slicers - Compare two Brands: https://youtu.be/exN4nTewgbc

[Pbiuserr]

Yes but for multiple slicers, not one and I cant put only one measure in a chart