Goal Data not showing up

[Anonymous]

Hi everyone,

My monthly goal number is not showing up for a California since there is currently no sales in that state. 

I have a Date Table that I thought would bring in the goal number regardless if there are sales.  Since there is no sales yet, there is no date for the goal table to reference.

Anyone have any ideas how to get the goal number to show up at all times?

Thanks in advance!

[KWelsh8144]

Does anyone have a solution for something like this? Goals are unique per location, but some months do not have any values but we still need the goal to show.

[v-luwang-msft]

Hi @Anonymous ，

Could you pls show more details,or show your pbix file?Remember to remove confident data.

In my opinion,it seems to me that if no filter is set, you should be able to see all the data, even if the sales value is empty, and the other sales value is a column, or a measure?

And if your questions solved,could you pls share your solution.

Best Regards

Lucien 

[amitchandak]

@Anonymous , if you have a sales table and goal table and both joined to date table. Then visual should show goal even if the sales is not there.

Unless, the measure do not show goal if sales is blank

there is visual level filter to remove empty sales data