Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

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 @Anonymous ,

 

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

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

Anonymous
Not applicable

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

 

Thanks

Hi @Anonymous ,

 

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!

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.