The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now
Dear community,
I am trying to create a new slicer for a financial report that needs to combine entries from two unrelated tables.
I got the following two tables: REGION and BUSINESS UNIT
Table REGION contains:
Table BUSINESS UNIT contains:
My aim is to create be able to deselect the combination "ASIA PACIFIC" & "Consumer" from a given report.
I already created a new table combining the two tables using the GENERATE function
GENERATE (table REGION, table BUSINESS UNIT)
Besides, I added a new column to find the combination of ASIA PACIFIC and Consumer, which gives me the following
Table REGION & BUSINESS UNIT
Region | Business | ASIA PACIFIC & Consumer |
EMEA | Premium | NO |
EMEA | Consumer | NO |
EMEA | Industrial | NO |
... | ||
ASIA PACIFIC | Consumer | YES |
I linked the original tables REGION and BUSINESS UNIT to this new table on the relevant columns (REGION on REGION and BUSINESS UNIT on BUSINESS UNIT) using a 1:M relationship.
However, when I pull in the new column "ASIA PACIFIC & Consumer" and try to select "YES" or "NO" the figures in the report at not responding at all.
I assume that it is due to the 1:M relationship of my new table and it might be to wrong approach to begin with.
'
Hopefully, some of you smart guys have a suggestion on this matter and on how to solve it.
Looking forward to your proposals and wish you a great weekend once you get there.
Solved! Go to Solution.
Hi @tgruenheit ,
Altough this two tables are unrelated are they related with the other table you have your main data, where you want to make the calculations?
If you already have a relationship between those tables and the other one you can turn on the filtering for both sides and one will influence the other.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @tgruenheit ,
Altough this two tables are unrelated are they related with the other table you have your main data, where you want to make the calculations?
If you already have a relationship between those tables and the other one you can turn on the filtering for both sides and one will influence the other.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em Português@MFelix thanks mate, this seems to work out. I changed the setting on one of the relationships and that seems to do the job. Appreciate your swift reply. 🙂
User | Count |
---|---|
158 | |
109 | |
96 | |
83 | |
75 |
User | Count |
---|---|
154 | |
137 | |
131 | |
81 | |
62 |