blank data visual

[bzeeblitz]

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

[v-nmadadi-msft]

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

[v-nmadadi-msft]

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

[v-nmadadi-msft]

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.

[v-nmadadi-msft]

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.

[collinq]

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.

[bzeeblitz]

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.

[v-nmadadi-msft]

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 command

DateTable = 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