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 Everyone,
I have made 2 column charts and both of them have different data sources.
Age groups and Reference numbers are different in both the cases.
How can I merge these two graphs where the values on the x axis remain the same and I can see the data like this picture
Solved! Go to Solution.
Hi @ashmeet50,
New a calculated table:
TB3 = UNION ( ADDCOLUMNS ( TB1, "Legend", "Source1" ), ADDCOLUMNS ( TB2, "Legend", "Source2" ) )
Then, create group bins based on [Age] in "TB3".
Best regards,
Yuliana Gu
Hi @ashmeet50,
Above error is caused by typing the DAX formula into a measure.
What you need is a calculated table as highlighted in below screenshot.
Best regards,
Yuliana Gu
Hi @ashmeet50,
New a calculated table:
TB3 = UNION ( ADDCOLUMNS ( TB1, "Legend", "Source1" ), ADDCOLUMNS ( TB2, "Legend", "Source2" ) )
Then, create group bins based on [Age] in "TB3".
Best regards,
Yuliana Gu
Hello Yuliana,
I am getting an error message
The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value.
Ashmeet Singh
Hi @ashmeet50,
Above error is caused by typing the DAX formula into a measure.
What you need is a calculated table as highlighted in below screenshot.
Best regards,
Yuliana Gu
You need to create a relationship between this two tables, what is your key field? Maybe you will need to create a auxiliar table, with a distinct list of this key value and then connect this two tables to a new auxiliar table.
Show some example of this data, it will help us to demonstrate.
For eg. I have 2 data sets such as
Reference number | Age |
xyz123 | 23 |
ery 245 | 56 |
asd45456 | 67 |
vsvc5656 | 34 |
gsfxgvd4545 | 678 |
asdas | 34 |
dsad | 56 |
fghfh | 568 |
and
Reference number | Age |
ffe | 533 |
edf | 545 |
eeq | 5454 |
qeqe | 234 |
ew | 768 |
asasas | 567 |
e | 789 |
sasewd | 433 |
And the way I am doing right now is
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 |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |