Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
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.
@Pbiuserr , Not very clear, do you need something like
Compare Categorical Data Using Slicers - Compare two Brands: https://youtu.be/exN4nTewgbc
Yes but for multiple slicers, not one and I cant put only one measure in a chart
User | Count |
---|---|
93 | |
83 | |
77 | |
74 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |