Applying relative filters to the report but displaying blank values in the service

[neelofarshama]

Hi,

I have a report which displays below information but the highlighted feilds are displaying "BLANK" in service.

service:

below is report link. I have also created a seperate Date table but values are still throwing wrong. Please help me to resolve this.

https://caltimes-my.sharepoint.com/:u:/g/personal/neelofer_shama_latimes_com/EUjSWd-GrCxHu_TDG15F1B4....

Thanks in Advance,

Neelofar.

[amitchandak]

@neelofarshama , I published this file and check I am getting data. What is happing is you might have removed the filter while check, not that is not going away .

Clear Browser cache -> Refresh/Rest parameter

or

Republish- > Clear Browser cache -> Refresh/Rest parameter

Also, my advice would be use date table

PowerBI Abstract Thesis: Why Time Intelligence Fails - Powerbi 5 Savior Steps for TI :https://youtu.be/OBf0rjpp5Hw

https://amitchandak.medium.com/power-bi-5-key-points-to-make-time-intelligence-successful-bd52912a5b...

[neelofarshama]

Hi amitchandak,

Thank you for the reply I tried adding a new date table but still facing problems. The Last week is shoing as BLank and other as Infinite.

Please suggest.

[v-easonf-msft · Accepted solution]

Hi, @neelofarshama 

Have you tried to edit the report on the service? Please recheck the filter of each visual  on your service.

In addition, need to notice that the utc on the service may not consistent with the local one. 

You can check the following related links:

Power BI: (Workaround) Power BI Service only provides UTC-based relative date and time filters 

Handle local time zone in Power BI service 

Set local time zone Power BI Service 

Best Regards,
Community Support Team _ Eason