Forum Discussion
AmiraBedh
Super User
Super UserShow items with no data is not giving expected result
I am using a Live connection to an SSAS tabular model having the following tables : Employees : all Employees in the company Employees VIP : Employees having the status of VIP in the company ...
I ended up finding the answer to this behavior :
https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-show-items-no-data
It's important to note that the mechanism of selecting values for the columns is order-dependent, and can be thought of as a Left outer join operation between tables. If the order of the columns is changed, the results change as well.
powerbi - Show items with no data is not giving expected result - Stack Overflow
parry2kSuper User
Super UserAmiraBedh Very hard to reach, I wish you had put that as the code. Can you share the sample pbix file to look into it?
AmiraBedhSuper User
Super UserYou can find the link to Google Drive : https://drive.google.com/drive/folders/1-rk-VKwYrGdbY7q_cjk_3TlBbAtH3U-H?usp=sharing