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.
Hi Everyone,
I have a problem with implementing new data from the data reports into my Power Bi model.
I used to have one center table which connected all my other data tables:
Account Group: |
EMEA |
North America |
Asia |
Now, I have to implement some newly formed Sub-Groups (which are already in the data tables, however not yet in the center table, as I would like to be able to filter on the Sub-Groups on all pages).
Account Group: | Sub Group: |
EMEA | Central Europe |
EMEA | UK & Middle East |
EMEA | Southwestern Europe |
EMEA | Northern Europe |
North America | North America |
Asia | APAC |
I already tried to:
As I would like to filter on all pages of my Power Bi report, I want to keep the Account Group center table. Is there a way to 'plug' the new data table into the existing center table without any errors occurring? (seems for me to be the easiest solution)
Or is there a way to set up two center tables which connect all other data tables and lets me filter on the two different groups?
Are there any other approaches or suggestions?
I would appreciate any help.
Thanks in advance.
Best regards,
Patric
Hi @patricPBI
If the above posts help, please kindly mark it as a answer to help others find it more quickly. thanks!
If not, please kindly elaborate more.
You can upload the dummy pbix to the onedrive for business and share the link here. please don't forget to disclose the expected results and remove the confidential info.
@patricPBI
Assuming the Sub Group field is on your data tables you should be able to
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 |
---|---|
107 | |
97 | |
75 | |
63 | |
62 |
User | Count |
---|---|
139 | |
104 | |
104 | |
80 | |
66 |