Forum Discussion

Fern_21's avatar
Fern_21
Helper V
1 year ago

Table visualization error due to missing relationship

Hi all! I need to display a table visual in Power BI with fields from the following tables: Tags, Models, and Spare Parts. If I add the Tags and Models fields or the Spare Parts and Models fields,...
Need Help
rajendraongole1's avatar
rajendraongole1
Super User
1 year ago

Hi Fern_21   - Since the tags table isn't directly related to spare_parts, create a measure to retrieve the associated spare parts. Use a Measure Instead of Direct Fields as like below

Eg: 

Spare_Part_List =
VAR _SpareParts = CONCATENATEX(
RELATEDTABLE(spare_prts_models),
spare_parts_models[id_spare_part],
", "
)
RETURN _SpareParts

 

 

Hope this helps.

  • Fern_21's avatar
    Fern_21
    Helper V
    1 year ago

    Hi rajendraongole1 !

    Can I use this measure to correctly display the spare_part field within the table?

    • rajendraongole1's avatar
      rajendraongole1
      Super User
      1 year ago

      yes ofcourse, use it as per your shared snapshot. I have used table names. please check the table names and use it. 

       

      Let me know if it works, if not please share some sample data for reference by removing the sensitive data in your pbix file.

      • Fern_21's avatar
        Fern_21
        Helper V
        1 year ago

        Hi rajendraongole1 !
        I've inserted this measure, but now I get this error. "The visual has exceeded the available resources. Try filtering to decrease the amount of data displayed"
        How can I solve it?