Forum Discussion
Display data till current date only (used items with no data because nature of the data)
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 !!
Hi,
Here's what i got. PBI file attached.
8 Replies
Make your straight line measure return BLANK() for all future dates.
I tried to remove the straight line earlier but still couldn't solve the issue
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-Forum/ba-p/963216
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
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))RETURNSaleuptocurrent
Hopefully this will fulfill your requirement.Thanks
Harish M
Did I answer your question? Mark my post as a solution! Appreciate your Kudos
