cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
suren947
Helper I
Helper I

Matrix data show issue

Hi All,

 

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

 

Thank. 

 

Pleae suggest.

1 ACCEPTED SOLUTION

Hi @suren947 ,

 

Click on the drop down arrow in the field of ID>choose"show items with no data":

vkellymsft_0-1632386220916.png

 

 

 

 

 

Best Regards,
Kelly

Did I answer your question? Mark my reply as a solution!

View solution in original post

3 REPLIES 3
amitchandak
Super User
Super User

@suren947 , use +0 in your measures and try.



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Since data is only raw data, we are showin any measure. 

 

Thanks

Hi @suren947 ,

 

Click on the drop down arrow in the field of ID>choose"show items with no data":

vkellymsft_0-1632386220916.png

 

 

 

 

 

Best Regards,
Kelly

Did I answer your question? Mark my reply as a solution!

View solution in original post

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!