Forum Discussion

Krzysztof1's avatar
Krzysztof1
Regular Visitor
1 year ago
Solved

relationship

Hi Can I create relationship between tables with only text data ( no values)?

  • Hi Krzysztof1 -Yes, you can create relationships between tables in Power BI based on text data columns, even if the columns do not contain numeric values.

     

    ex: i have taken empl with text data and summar with text and one date field. we can do it. 

     

     

    if you have any reference data please share it. 

     

    Hope it helps.

     

     

4 Replies

  • Hi Krzysztof1 -Yes, you can create relationships between tables in Power BI based on text data columns, even if the columns do not contain numeric values.

     

    ex: i have taken empl with text data and summar with text and one date field. we can do it. 

     

     

    if you have any reference data please share it. 

     

    Hope it helps.

     

     

    • Krzysztof1's avatar
      Krzysztof1
      Regular Visitor

      Thank you I had a problem in Power Pivot in Excel with selected unique columen with text but when I used Power bi it works Thx Greetings from PL

  • Krzysztof1's avatar
    Krzysztof1
    Regular Visitor

    Hi Many thx for the fast response. I had the problem when I was trying set up pivot table on Power pivot excel. In Power bi it works Thx