visuals not properly interacting with slicer in power BI service.

[Neha_Shukla]

When I am trying to do select value in slicer, other visuals showing blank.how to fix this issue.

[v-yangliu-msft · Accepted solution]

Hi  @Neha_Shukla ,

Whether the functions of Now() and Today() exist in your dax formula, the Today() function on the Power bi service returns today’s value according to the UTC() time zone, while the Today() function on the Power bi desktop shows the computer’s system time, so in Power bi service, your time zone and standard time are different, resulting in data not appearing.

https://radacad.com/solving-dax-time-zone-issue-in-power-bi

https://www.linkedin.com/pulse/power-bi-service-time-differences-how-fix-aaron-watsky

For example:

The time zone in Power BI Service is based on UTC. My time zone is 8 hours apart from UTC.

I used now() function, displayed in power bi desktop:

Display in power bi service:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi @Neha_Shukla

Could you please explain the issue in detail. I could help you in case I understand your issue clearly.

Best,

Kavya

[Neha_Shukla]

Hi @Anonymous 

My data source connection is power app for activity time tracking.

I have made this dashboard to track time and overall working time.

I have made date slicer due to which I can track activity of particular day.

my dashboard is working fine in desktop but once its getting publish in service its showing inapporiate value and blank visuals.schedule refresh is successfully compleated but visuals are blank once I made some selection on date slicer.

Is this issue is coming from date table or from service part or from somewhere else.

I have made calendar table from starting of this jan month till today's date.which is showing correct in desktop.but in service date is not getting correct values as per calendar table.how to fix this?

[Anonymous]

Hi @Neha_Shukla ,

Try to check the source column used for your slicer is in required 'Date/Time' data type and also see through that all your slicers are connected with your card visuals using the 'edit interactions' in 'Modelling' tab.

Hope, this would help you.

Regards,

Kavya