Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
We have developed power BI report and there are couple of filters has been added, among them two of it having issue which are Year and Month filters, for those filters default values has been assigned as Current FY and Current month, but during first load of report the both filter values indicating as 'All' and once we trigger the drop down action in filter it changes to Current FY.but if we view the report through Power BI Desktop every thing works as expected.
Could someone please provide comment on this issue.
Regards,
Solved! Go to Solution.
Hi Lin,
Yes. may be it's a temporary issue. i wll repost if it occures again.
Thanks for your support Lin
Regards,
Azhara
hi, @azharra
I have test on my side, it is the in power bi service and power bi desktop.
When change the type of slicer, value will be removed.
Best Regards,
Lin
It's only in power bi service, power bi desktop works as usual
For the first time of report loading filters shwoing as below
Image 1
But it has to be as below,
Image 2
currently to get this image 2 visual,we need to trigger click on filter.other wise it remains as image 2, even if we see the 'All' ,visual values has populated according to CurrentFY and CurrentJC. i was cheking on other power bi report also from diffrent workspace as well. same thing happening, earlier it was working fine without any issue.
hi, @azharra
I'm a little confused by your description. According to my knowledge, it is not possible to set a default value for slicer.
when you log out of Power BI and come back to a report, the same items will be selected as when you left.
Best Regards,
Lin
Report which has ben developed through PBI descktop which has Year slicer and before we publish to PBI service we have kept CurrentFY selected.
we used to save report as below and pulbish it to PBI service.
then in PBI service Year slicer should show CurrentFY right. even if we saved with above selections still Year and Month filter shows 'All' selection.
But when we drop down and see the filter selection in PBI service Year filter shows the selection which has been saved under PBI desktop, which is correct filteration.
Problem here is that Filter visual shows 'All' selection even filteration has been done for CurrentFY and CunnetMonth.
Thanks
hi, @azharra
I have test on my side. It works well.
For example:
In power bi desktop, I set two slicer selected two value
then I publish it to power bi service. it works well
Could you try to clear browser cache and try it again? and what is your browser?
If possible, could share a simple sample pbix file for us have a test?
Best Regards,
Lin
Hi,
I just checked now. it seems okay, very strange.
Thanks,
hi, @azharra
Great! It's pleasant that it works. I suspect that it is a temporary issue.
If you consider this issue closed, please mark it as "solved". Thanks.
Regards,
Lin
Hi Lin,
Yes. may be it's a temporary issue. i wll repost if it occures again.
Thanks for your support Lin
Regards,
Azhara