Forum Discussion
blank data visual
i have used sharepoint list in visuals and its looks below
Date count item
march1
march2 2 120
so i have used powerautomate to extract the above powerbi data and store the above report data into sharepoint list.so i copied the powerbi query in powerautomate flow poweri bi datasets contains dax query and update sharepoint list item.so when my count is blank then my flow is not creating any item,insted i need to store count 0 against the date.
sharepoint list-target list
so when i check march1 there are no entries since data in power bi is blank
Current issue in sharepoint list
item# date
Expected output
item# date count
march1 0
7 Replies
HI bzeeblitz ,
If I am understanding you correctly, I think the best bet is to add into your Power Automate something that adds "if date is blank, add date with a '0' "
If not, what you will need to do in Power BI is hook the output to a date dimension table and then you will have every available date and you can put a count column in your report that will show a "0" for any of the dates that do not exist in SharePoint.Thanks a lot.
But this point I'm not sure how to hook output to the date dimension table in
power bi
If not, what you will need to do in Power BI is hook the output to a date dimension table and then you will have every available date and you can put a count column in your report that will show a "0" for any of the dates that do not exist in SharePoint.
Hi bzeeblitz,
Thanks for reaching out to the Microsoft fabric community forum.
Thanks collinq for you valuable points.
You can create a data table in power BI using this DAX commandDateTable = ADDCOLUMNS ( CALENDAR (DATE(2024,1,1), TODAY()), "Year", YEAR([Date]), "Month", FORMAT([Date], "MMMM") )
Modify the start date as you seem fit.
Then Create a Relationship, navigate to Model View in Power BI and establish a one-to-many relationship between the DateTable[Date] column from the Date Table and the [Date] column in your fact table, which contains the count values.
Finally Create a new measure that ensures missing dates show 0:TotalCount = VAR CountValue = SUM('FactTable'[Count]) RETURN IF( ISBLANK(CountValue), 0, CountValue)
Now, whenever there is no data for a date, the count will show 0 instead of being completely omitted.Hope this workaround will fix your issue in sharepoint.
If you find this post helpful, please mark it as an "Accept as Solution" and consider giving a KUDOS. Feel free to reach out if you need further assistance.
Thanks and Regards
Hi bzeeblitz,
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.
Hi bzeeblitz,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If our responses has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.Hi bzeeblitz,
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the community members for the issue worked. If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.
Thanks and regards
Hi bzeeblitz
Could you please confirm if your issue has been resolved If so, sharing the details here would be helpful for other community members who may have similar feedback.If we don’t hear back, we’ll go ahead and close this thread. For any further discussions or questions, please start a new thread in the Microsoft Fabric Community Forum we’ll be happy to assist.
Thank you
