cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
neelofarshama
Post Partisan
Post Partisan

Power BI service displaying wrong values but not in desktop

Hi I have a report which is displaying correct values in the desktop but in service it showing as Blank. I am using some page filters in the report for which I am getting correct results in desktop but the filters(Relative) are not being applied in the service, only basic filter is being applied here.

Power BI service image with filters

neelofarshama_0-1640167347068.png

Desktop image with filters:

neelofarshama_1-1640167404620.png

 

Desktop:

neelofarshama_0-1640166001413.png

Service:

neelofarshama_1-1640166072134.png

Can you tell me why?

2 ACCEPTED SOLUTIONS

Hi, @neelofarshama 

 

Do you put the report in the premium capacity? You can only put it in shared capacity or ppu capacity temporarily.

I found the issue of ‘Relative date filter does not work on Premium but works on Shared capacity and Desktop’.

This issue has been submitted internally. Internal ICM ID:278394986 Please be patient to wait for fixing. If there is any news, I will update it here.
 
Best Regards,
Community Support Team _ Janey

View solution in original post

Hi, @neelofarshama 

 

Update: 
This issue has not been fixed yet.
The transition workaround is: move to Gen2

vjaneygmsft_0-1641548679622.png

 

What is Power BI Premium Gen2? - Power BI | Microsoft Docs

 

Best Regards,
Community Support Team _ Janey

View solution in original post

9 REPLIES 9
neelofarshama
Post Partisan
Post Partisan

Hi,

I have a report displaying Previous month, previous quarter, previous week, previous year

for these measures I added relative filter to display "in the last 1 calendar month" and it worked fine in desktop but when published in service it is showing BLANK values can you explain why?

neelofarshama_0-1640192570172.png

Service

neelofarshama_1-1640192618347.png

Previous Period = CALCULATE(sum(DSI_STARTS_STOPS[STARTS]),PREVIOUSMONTH(LASTDATE(DSI_STARTS_STOPS[Month_Date])))
Previous Year Period = CALCULATE(sum(DSI_STARTS_STOPS[STARTS]),SAMEPERIODLASTYEAR((DSI_STARTS_STOPS[Month_Date])))
Previous Quarter = CALCULATE(sum(DSI_STARTS_STOPS[STARTS]),PREVIOUSQUARTER((DSI_STARTS_STOPS[QUARTER_DATE])))
Previous Year Quarter = CALCULATE(sum(DSI_STARTS_STOPS[STARTS]),SAMEPERIODLASTYEAR((DSI_STARTS_STOPS[QUARTER_DATE])))

If relative filter is not working any DAX suggestions would help me out.

Thanks in Advance,

Neelofar

 

@neelofarshama , You should always use date for a table for Time Intelligence

Previous Year Period = CALCULATE(sum(DSI_STARTS_STOPS[STARTS]),SAMEPERIODLASTYEAR((Date[Date])))

 

Why Time Intelligence Fails - Powerbi 5 Savior Steps for TI : https://youtu.be/OBf0rjpp5Hw

 



New Power BI Features
Datamarts: https://youtu.be/8tskWsJTEpg
Field Parameters : https://youtu.be/lqF3Wa1FllE?t=70
Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! !!
Dashboard of My Blogs !! Connect on Linkedin !! Proud to be a Super User!
Want To Learn Power BI
Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
!! Subscribe to my youtube Channel !!
v-janeyg-msft
Community Support
Community Support

Hi, @neelofarshama 

 

I downloaded your sample file and published it to my workspace, but I didn't find your problem. 

Like this:

vjaneygmsft_1-1640585118829.png

Have you downloaded the latest version of desktop? Try it:

Download Microsoft Power BI Desktop from Official Microsoft Download Center

Try to refresh the report, or republish the report. It should work.

 

Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.

 

Best Regards,
Community Support Team _ Janey

Hi @v-janeyg-msft ,

 

Thanks for the reply, I updated the dekstop version to the lastest one but still the problem is existing. Could you please suggest me DAX for my requirement so that I cannot apply filters.

 

Thanks in Advance,

Neelofar

Hi, @neelofarshama 

 

Do you put the report in the premium capacity? You can only put it in shared capacity or ppu capacity temporarily.

I found the issue of ‘Relative date filter does not work on Premium but works on Shared capacity and Desktop’.

This issue has been submitted internally. Internal ICM ID:278394986 Please be patient to wait for fixing. If there is any news, I will update it here.
 
Best Regards,
Community Support Team _ Janey

Hi @v-janeyg-msft ,

 

Yes I am using premium capacity. Thank you for the help please keep me posted on any recent updates.

Hi, @neelofarshama 

 

Update: 
This issue has not been fixed yet.
The transition workaround is: move to Gen2

vjaneygmsft_0-1641548679622.png

 

What is Power BI Premium Gen2? - Power BI | Microsoft Docs

 

Best Regards,
Community Support Team _ Janey

@neelofarshama 

 

This is very strange, because you have posted several posts for one issue, I viewed and downloaded your sample in one of the posts,  I didn't modify any dax code and there is no difference in the content between my desktop and service.

Do you have other machine to view the report in pbi service?

amitchandak
Super User
Super User

@neelofarshama , First thing to try.

1. Clear browser cache -> refresh and check

2. Republish -> Clear browser cache -> refresh and check

 

if not

Can you share a sample pbix after removing sensitive data.



New Power BI Features
Datamarts: https://youtu.be/8tskWsJTEpg
Field Parameters : https://youtu.be/lqF3Wa1FllE?t=70
Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! !!
Dashboard of My Blogs !! Connect on Linkedin !! Proud to be a Super User!
Want To Learn Power BI
Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
!! Subscribe to my youtube Channel !!

Helpful resources

Announcements
June 2022 update 768X460.jpg

Check it out!

Click here to read more about the June 2022 updates!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power BI Dev Camp Session 23 768x460.jpg

Check it Out!

Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!

June 20 episode 7 with aka link 768x460.jpg

The Power BI Community Show

Join us on June 20 at 11 am PDT when Kim Manis shares the latest on Azure Synapse analytics, the Microsoft Intelligent Data Platform, and notable Power BI Updates from Microsoft Build 2022.

Top Solution Authors