Curious - can I compare/correlate 02 tables in 01 column graph?

[jr3151006]

Hi,

I was wondering if it's possible, since do I need do the countrows (distinct) for 02 different tables (table1 and table2), based on a slicer defined period, then put on the same graph on a page.

Is that possible?

Take a look that image.

[jr3151006]

I think that was accomplished after put the MONTH in 'X-Axis' which coming from Calendar (dimension table) and also put two DAX coming from each table into 'Y-axis'.

[v-jingzhang · Accepted solution]

Hi @jr3151006 

Yes, you can add multiple fields to Y-axis. You can add columns with a proper aggregation, or add measures. Ensure that the dimension date table is connected to both tables where the y-axis fields are from. 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.