The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hi,
I need to show a Clustered chart with date column and planned values from one table and date and planned value from other table,
Is there any way to do so,
Or, How to Merge 2 tables, Date and planned with Date and Budget columns
Thanks in advance
@Ahmad_16 , There is no need to merge tables. Create connection between tables and you can proceed with the visual in a normal way.
it doesn't work with this, there is no key field, and even the dates are not the same.
need to merge them in one table first
@Ahmad_16 Go to transform data/power query. There in combine group there is an option to merge queries/tables.
User | Count |
---|---|
86 | |
84 | |
35 | |
35 | |
35 |
User | Count |
---|---|
94 | |
79 | |
63 | |
55 | |
52 |