How to streamline data in a Power BI matrix

[goyalsa]

Hi Everyone,

https://1drv.ms/u/s!ApGsTx0zWYrbiVJU2aO-3s6VaWZY?e=Ltlf5P 

Please find the attached link as a sample file. 

In the Power BI matrix, I want to make it like the excel screenshot below. but I do not know how to get the target sale for Month 202201 for North America as it is showing null because of no sale in that month.

Appreciate your help. Thanks in advance!!

Kind regards,

Sahil Goyal

[vanessafvg]

if you want to model this properly.

1. First you need to create a date table that you link both target an order tables to, same with your countries, separate the country  values into its own table and link to both target and orders

2. add the date data to the target separately.

then you can create a measure that will add a zero when there is no value

orders = if(ISBLANK(sum(Orders[Orders])),0, sum(Orders[Orders]))

or even orders = sum(Orders[Orders]) + 0 might work

you will need to remodel this to get it to work properly

[goyalsa]

Hi @vanessafvg ,

Thank you for the suggestion but it is not working out.

Kind regards,

Sahil Goyal