Solved: Values in a Matrix when the result is 0

joaquinel · ‎11-06-2022

I have a Matrix where I use the days of my calender table. I want to see all the days of the month even when there is no result.

Thanks

Jihwan_Kim · ‎11-06-2022

Hi,

I am not sure how your desired outcome looks like, but I think you can try selecting an option called "show items with no data".

Please check the link down below.

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Click here to visit my LinkedIn page

Click here to schedule a short Teams meeting to discuss your question.

Ashish_Mathur · ‎11-06-2022

Hi,

Once you drag Date from the Calendar Table, write this measure and drag it to your visual

Total = coalesce(sum(Data[sales]),0)

Hope this helps.

Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Jihwan_Kim · ‎11-06-2022

Hi,

I am not sure how your desired outcome looks like, but I think you can try selecting an option called "show items with no data".

Please check the link down below.

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Click here to visit my LinkedIn page

Click here to schedule a short Teams meeting to discuss your question.

Values in a Matrix when the result is 0