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.
Dear community,
i am looking for a help, i have 2 tables visuals in power, see below
i need to combine this together with one table, here is the attached sample file for your reference
https://www.dropbox.com/s/5br41pxhnk1ve0x/Test.pbix?dl=0
Hi @vjnvinod,
Based on your pbix file, If you want to achieve the output like append, I'm afraid that we may not join the table directly.
Here is a workaround, we could use UNION function to join the table. However, for your sceanrio, if we use UNION fucntion, the performance won't be well and it will show more rows. If your visual level filer is changed, you need to change the formula manully.
If you want to use UNION, you could refer to the formula below.
Table 3 = UNION ( SELECTCOLUMNS ( FILTER ( 'Inbound', 'Inbound'[HQArea] <> "Americas" && 'Inbound'[HQArea] <> "Asia-Pacific" && Inbound[HQArea] <> "EMEIA" && Inbound[HQArea] <> "Japan" ), "HQArea", 'Inbound'[HQArea], "TER_FYTD_USD", 'Inbound'[TER_FYTD_USD], "Growth.", [Growth.] ), SELECTCOLUMNS ( FILTER ( 'Inbound', 'Inbound'[Inbound] <> "Inbound from Americas" && 'Inbound'[Inbound] <> "Inbound from Asia-Pacific" && 'Inbound'[Inbound] <> "Inbound from EMEIA" && 'Inbound'[Inbound] <> "Inbound from Japan" ), "HQArea", 'Inbound'[DeliveryArea], "TER_FYTD_USD", 'Inbound'[TER_FYTD_USD], "Growth.", [Growth.] ) )
In another workaround, we could pin the two tables like below.
Best Regards,
Cherry
thanks for this, i think both solutions doesn't hold good.
In excel we could have done this very easily, unfortunately power BI is not helping to get there.
is there any alternative approach we can take to get their?
just wondering, something in power query, where some calcualte coloumns or some criteria to set this up?
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 |
---|---|
112 | |
97 | |
82 | |
67 | |
61 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |