Forum Discussion
Look up data filed based on a other column
Hi,
I am a newbi on Power BI, I want to make a KPI of Report of Tasks grouped by Report status and showed by Group;
The visualisation that I want to use is Histogram.
I have 2 lists.
First one, concern the GroupeName
| GroupeID | GroupeName |
| 349 | Assurance Fournisseur |
| 353 | GP Ordonnancement PS |
| 343 | GP Ordonnancement U |
| 348 | Ilot U |
| 346 | Laboratoire Qualité |
| 553 | Maintenance PU |
| 344 | Maintenance S |
The econd one, concern the Tasks :
| ReportId | ReportStatus | GroupeID |
| 1 | Completed | 349 |
| 2 | In progress | 353 |
| 3 | Completed | 343 |
| 4 | Completed | 348 |
| 5 | In progress | 346 |
| 6 | Completed | 553 |
| 7 | Completed | 344 |
| 8 | Completed | 349 |
| 9 | In progress | 353 |
| 10 | Completed | 343 |
| 11 | Completed | 348 |
| 12 | In progress | 346 |
| 13 | Completed | 553 |
| 14 | In progress | 344 |
In x-axis, i put GroupeID
In Legend I put ReportStatus
In Values, I put Number of ReportID
The following image, is the result of my KPI :
But I want to make a report like the following image :
I want to show GroupNames of the other list... bu I dont know how to proceed.. Have you got any idea or tips for me ? Please
I think I have to make a Look UP value of GroupID columns or to create a new column with a lookup... I am o confudes..
Need your help, please..
Thanks in advance,
Regards,
Antoine MICK
Hello,
Thanks bcdobbs , Your PBIX file helped me to find a Issu for my problem !
I use detect relations, I delete a relation and added manually a relation between my two culomns or a new ID and thats it run as well !!
Regards,
Antoine MICK
4 Replies
- bcdobbs
Community Champion
If you create a relationship between group id's on the two tables you should be able to drop the group name straight in. Will mock a demo up later this evening and send a link.
- bcdobbs
Have a look at: Example File
There is a one to many relationship between Groupe and Task.
I've used the stacked bar visual and put the following in the properties:
Hope this meets your needs.
Hello,
Thanks bcdobbs , Your PBIX file helped me to find a Issu for my problem !
I use detect relations, I delete a relation and added manually a relation between my two culomns or a new ID and thats it run as well !!
Regards,
Antoine MICK
Hi AntoineMICK,
Did bcdobbs 's suggestions help with your scenario? if that is the case, you can consider Kudo or accept his suggestions to help others who faced similar requirements.
If that also doesn't help, please share more detailed information to help us clarify your scenario to test.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
