I have two tables connected using key (ID+date) & Many:Many(Both).
Matrix shows data when data is available in both tables for any specifc date and not showing any data from both tables if data is not available in one table for any specifc date
My requirement is show data in Matrix if data is available in atleast one table for any specifc date
Go to Solution.
Hi @suren947 ,
Click on the drop down arrow in the field of ID>choose"show items with no data":
Did I answer your question? Mark my reply as a solution!
View solution in original post
@suren947 , use +0 in your measures and try.
Proud to be a Super User!
Since data is only raw data, we are showin any measure.
Check out the News & Announcements to learn more.
Click here to read more about the October 2021 Release!
Check out the new Power Platform Community Connections gallery!
Mark your calendars and join us for our next Power BI Dev Camp!