Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
104 | |
78 | |
68 | |
61 |
User | Count |
---|---|
144 | |
106 | |
106 | |
82 | |
70 |