Forum Discussion
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...
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 screenshotI have attached my testing pbix file. Hope it will help you.
May i know why you are using Directquery??Regards
sanalytics
Consider using "Show items with no data".
Consider disconnecting the tables and use measures.
Be aware that you can add calculated columns to Direct Query sources under specific circumstances.
The dataset is too large to use Show Items with no data. When I use that option, the visual and page filter don't work anymore.