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.

Visit my LinkedIn page by clicking here.

Schedule a meeting with me to discuss further by clicking here.

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.

Visit my LinkedIn page by clicking here.

Schedule a meeting with me to discuss further by clicking here.

Values in a Matrix when the result is 0