Filled map not showing when filtered to latest date

[newgirl]

Hello!

I have sample file with 2 tables - sales table and calendar table.  In the sales table, the last date that has volume transactions recorded is June 8.

In the page of my report, I have a slicer titled "as of" because I use it as "Today" default slicer once my report is going to be updated daily. Please take note that in our company, the sales report's  latest transactions are always those delivered or invoiced the previous day. Hence, my main measure is :

Yesterday = CALCULATE(SUM('CR tbl_phrawsales'[Actually billed amount]),PREVIOUSDAY('Calendar'[Date]))

So as you can see below, I have table showing per Region and Market (in which both columns are converted into Data Category as 'State or Province', and the Yesterday measure.

When I select my slicer date that is before the latest transaction date, the filled maps work. And as seen in the table, there really are values under Yesterday column per Region and per Market.

However, when I select the latest transaction date in the slicer (in this case, it's June 9), the filled maps don't work anymore but as seen in the table, there are values under Yesterday column per Region and per Market.

Is there something I'm missing to set up in filled maps? Hope somebody can help me.

[v-jingzhang]

Hi @newgirl 

It is because there is no data on June 9. When there is no data on a date, it will have no data point on the map visual. All result is blank. So it cannot format blank conditionally by a measure although the measure value is not blank. 

You need to provide "0" (or a negative number) as today's values for every region to replace blank. Then the conditonal formattig should work on the lastest date.

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[newgirl]

Hello @v-jingzhang I kind of get the concept you saidbut I don't udnerstand how to translate it in the actual file. Is it possible if I ask to apply it in my sample file with dummy values?

Here is my file: https://drive.google.com/file/d/1kbvCyks67bvwVgxx2BRebdlyShbjSGMi/view?usp=sharing

[v-jingzhang]

Hi @newgirl 

I add a market table to the model, and create a relationship between it and the sales table on market columns. Use this table's market column in the filled map. The sample file is attached at bottom. 

tbl_market = FILTER(DISTINCT('CR tbl_phrawsales'[Market]),'CR tbl_phrawsales'[Market]<>BLANK())

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.