Display data till current date only (used items with no data because nature of the data)

[saadghojaria]

Hi Fabric community , 
I have these graphs connected to Calendar table and due to nature of the data I need to display until only current month data only. When I try to use filter wrto date column (Calendar table) it doesnt reallly help. Can someone please help on this would be super helpful. 

Graph A : Tables used AFR and Calendar 

Graph B : Tables used Labor Hours , Calendar , CRP Table 

I tried this but I didnt really helped in my case not sure why. Remove months with no data BUT show all months between first and last dates even if blank 

Thankyou !!

[HarishKM]

@saadghojaria Hello,
Kindly follow below method--
1) you have to use below dax and this will limit data upto current month.

Dax - 

Data upto current date =

Var Currentmonth = TODAY()

Var Saleuptocurrent = CALCULATE(SUM(financials[ Sales]),FILTER(Calender,Calender[Date]<=Currentmonth))

RETURN

Saleuptocurrent



Hopefully this will fulfill your requirement.

Thanks
Harish M
Did I answer your question? Mark my post as a solution! Appreciate your Kudos 

[lbendlin]

Make your straight line measure return BLANK() for all future dates.

[saadghojaria]

I tried to remove the straight line earlier but still couldn't solve the issue

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

[saadghojaria]

Hi Here is the file you can download. Thanks again for taking time to help me really appreciate it. Also solution above @HarishKM provided seems not working for me. I have added that Dax too for the review. 
Items-with-no-data-example.pbix 

[Ashish_Mathur · Accepted solution]

Hi,

Here's what i got.  PBI file attached.

[saadghojaria]

Thanks Ashish , 
It worked for me !! 

[Ashish_Mathur]

You are welcome.