Forum Discussion

SkitteryJim's avatar
SkitteryJim
Regular Visitor
2 years ago
Solved

New to PBI - How to construct Text & Value List?

How do I construct a text and value selection list: Example List: Name (Text to be displayed) -  ID (Value hidden) James Smith                              109876 Ian Hunter                      ...
Need Help
  • lbendlin's avatar
    lbendlin
    2 years ago

    That is done via the data model. Use the ID to join the tables.

     

    To add reference data to Power BI you can click this icon 

     

  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi SkitteryJim ,

     

    Hi, how's the progress going? Did Ibendlin reply solve your problem? If so, please mark it as the correct solution, and point out if the problem persists.

     

    Best Regards,
    Adamk Kong

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

That is done via the data model. Use the ID to join the tables.

 

To add reference data to Power BI you can click this icon 

 

SkitteryJim's avatar
SkitteryJim
Regular Visitor
2 years ago

Thanks will give it a go and let you know how I progress.