Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Show rows without relationship in PowerBI visual

I have two table. One main table which is a direct query and a subtable which is an Excel-file. The two table are related to each other through two columns. However, there is not always a relationshi...
Need Help
  • sanalytics's avatar
    sanalytics
    1 year ago

    Anonymous 
    If your datasets is too much large then using Show items with No data is not recomended. Also, creating Calculated column can hamper your performance.. 
    what you can do, you can create a disconnected table and use that table for showing non relationship value. For example below screenshot

     

    I have attached my testing pbix file. Hope it will help you.

    May i know why you are using Directquery??

     

    Regards

    sanalytics

     

sanalytics's avatar
sanalytics
Super User
1 year ago

Anonymous 
If your datasets is too much large then using Show items with No data is not recomended. Also, creating Calculated column can hamper your performance.. 
what you can do, you can create a disconnected table and use that table for showing non relationship value. For example below screenshot

 

I have attached my testing pbix file. Hope it will help you.

May i know why you are using Directquery??

 

Regards

sanalytics