Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Desktop image with filters:
Desktop:
Service:
Can you tell me why?
Solved! Go to Solution.
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’.
Hi, @neelofarshama
Update:
This issue has not been fixed yet.
The transition workaround is: move to Gen2
What is Power BI Premium Gen2? - Power BI | Microsoft Docs
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?
Service
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
Hi, @neelofarshama
I downloaded your sample file and published it to my workspace, but I didn't find your problem.
Like this:
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’.
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
What is Power BI Premium Gen2? - Power BI | Microsoft Docs
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?
@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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.