Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Dashboard info changing when updating

Greetings, 

I have a simple dashboard with a relation on users and their % of loadwork (Each project has a % assigned and the SUM of it is what is showing) through time. It looks like this in PowerBI Desktop (For one specific user):

 

JRR_0-1620730086307.png

Once I publish it it looks correct. The problem is when I use the Update button on My Work Space or an automatic Update happens (I made it so everyday it updates), when this happens the dashboard looks like this:

JRR_1-1620730253888.png

As you can see, the % of work is nowhere near normal and it's impossible to use.

 

Does someone know what might be causing those issues?

3 REPLIES 3
MFelix
Super User
Super User

Hi @Anonymous ,

 

Do you have any filter on your report or changes in slicers that can affect this chart? 

 

Be aware that the changes in slicers of filtering are saved on the service so when you reopen your report it picks up the previous slicers settings. You can reset to default by clickin on top:

 

MFelix_0-1620820487443.png

If this is not the case what is the type of data source you are using?


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Anonymous
Not applicable

Greetings @MFelix !!

Sadly, reseting filters didn't help.

 

My data source is a SharePoint list, with the following columns:

 

Workload: Int (Coming from SHP as a String and changing it on transform data)

User: String

Date: Date dd/MM/yyyy (Coming from SHP as a String and changing it on transform data)

Project: String

 

It might be that the date is being changed due to the origin being a string?

 

Thanks!

 

Regards,

Joan

 

 

 

Hi @Anonymous ,

 

That can be hapenning, have you tried and change the list column to a date field?

 

Be aware that making this change if you field has an incorrect input you will loose your information.

 

Another option can be to use a dataflow to make your transformation.

For example if you have 13/05/2021 and the sharepoint list has a US regional setting the values need to be 5/13/2021 in order the change be correctly made.


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.