Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hi,
hope there is an easy solution to following issue. There are filters in visuals still active, that are no longer in there.
During the course of the development of the report, they have been there, yes. But as you can see in the screenshots - they are not in the pane, but still affecting the visual and in consequence the complete report
First example - a slicer
There are two fields, also listed as "filters on this visual" on the filter pane
But when you click on the filter symbol on the visual, you find a filter "OCFCL" still active, that isn't even there
the second example is a matrix. There are even more filters, that shouldn't be there. the OCFCL from above, plus ROSR, SVC and YEAR. Year is "great" - the visual shows filtered values, the pane says "All".
I tried everything, but I did not find a way to clear/clean the filters.
SVC = E means Export, and I need to create the same again for Import as well. Its a huge report with 26 pages and approx 8 visuals per page ...
Any ideas? Tips are highly appreciated
kind regards
Alexandra
p.s. Version: 2.109.801.0 64-bit (September 2022)
Hi @AlexandraF ,
Please correct me if I have misunderstood your question
Have you tried downloading this report as a pbix file and then disabling some irrelevant visual interactions you don't need in Power BI Desktop for report server and then republishing it?
Best Regards,
Community Support Team _ Caitlyn
Disabling the bugs plus adapting/amending of the filters that really exist. Sometimes those are identical. Like SVC - there is a "ghost"version set to "E" that's not accessible
And yes, I want to republish that second version, too
Some background, I am working in Logisitics, doing oceanfreight BI.
There is a origin/sending perspective (Service Export/SVC E) - that's the Export report that is running.
Now I need to prepare the receiving perspective (Service Import/SVC I). I tried both - download the pbix as well as "edit in PBI" and then save as Import. And there's where I found, that there are filters still active, that aren't in the reports filter pane any more.
And I haven't found a way to remove/disable those
Hope that helps - thanks for your support
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
3 | |
2 | |
1 | |
1 | |
1 |