Forum Discussion
Helper IIPage filters problems : interaction conflict
Hello,
I have to work on an old report (add some new fiscal years) but I'm quite lost with a filter problem, I don't know where to search for this issue.
We have a list of organisation, and as soon as I select one of them, the displayed Fiscal Years go back to the 3 original ones ( 2016 - 2017 / 2017-2018 / 2018-2019).
We also have an all page filter that limit the available years on each report.
I've noticed that the number "1" at the right of the fiscal year goes for "0" as soon as I've selected an Organisation.
I'm quite lost on where to search the issue.
Any idea ?
I've refreshed all the dataset, and all seem to be fine.
Thank you !
Before Organisation Selection
After Organisation selection
7 Replies
- amitchandak
Super User
NeimadB , is organization filter FY. Check the data model for that
NeimadBHello,
can you developp a bit more your answer ?
- Thejeswar
Hi NeimadB ,
I have come across a similar problem if one of the earlier queries posted. Will share the link below. May be this is the reason. Do check your Slicers applied in the report. Slicers take precedence over visual level filters
https://community.powerbi.com/t5/Desktop/Set-true-in-filter-pane/m-p/2027541#M761159
Regards,
- NeimadB
I've checked your link, but it seems that on my side the conflict occurs between tyo of my page filters.
(I also have a slicer on my reportm which displays only selected years)
- Thejeswar
Hi,
You said when you select an organization, the year goes from 1 to 0.
This could mean that there is no data for the years for that organization that you have selected. Hence the visual level filter shows 0 at the right of the value.
The Visual level filter by default shows all distinct values present in a column. Since Slicer takes precedence to Visual Level filter, once the slicer is selected, all the values available in the report post applying the slicer are shown as 1 in visual filter
Regards,
Hi NeimadB I am facing a similar issue, were you able to resolve this?
