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.
Hey, I have created a relationship between a results table and a targets table but if there isnt results for all of the channels I have targets for, the target shown is only the total target for the channels with results, for example:
If I have results table which ends up looking like:
Channel | Trasactions |
1000 | |
1000 | |
SMS | 1000 |
And a targets table which is:
Channel | Targets |
1100 | |
1000 | |
SMS | 1100 |
Phone | 500 |
And they have a relationship on Channel (bare in mind the results table will actually be per transaction), then when I make a Guage for results and targets the target shown will only be 3200 i.e. doesn't include Phone as there want any results, can anyone find a way around this as its not showing true values.
Thanks,
Harriet.
Solved! Go to Solution.
Sorry after some digging around I realised there was an error with one of the relationships.
Thanks!
H
Hey @mehaboob557 I cant quickly share it as I would need to make a completely new fake datafile instead of using the organisational data, Is there any ideas just considering the what i have explained?
Hi @H_Jones,
Please let me know is my understanding is right or not
you have results and target tables and i hope channels is the primary key.
you are having one-one relationship?
and what filters you are using?
So it is a one - many as the results table is a line per transaction and Channel is the Primary Key/used to create the relationship.
No filter used for the visual.
Sorry after some digging around I realised there was an error with one of the relationships.
Thanks!
H
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 |
---|---|
109 | |
95 | |
77 | |
65 | |
53 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |