Filter not showing properly

Question

Hi All,&nbsp;I face a peculiar problem where a filter is not showing although the same is visible in a table. Please find the screenshot for more info. I have been breaking my head on this but unable to identify the root cause. Any help would be deeply appreciated.Please see screenshot for more info. The phase is showing in the table but not in the filter.&nbsp;

anonymous · Answer

Looks like the graph is getting filtered but not the phase visual. What visual is 'phase'? Is it a Vcard? What DAX have you used for it?

kolumam · Answer

Hi Nikhil,&nbsp;The visual is just a slicer. Phase is just a field. The issue is when I put a page level filter for the months to show from March 18 to April 19. When I remove the page level filter the phase is showing all the options. What's the best way to go about?

anonymous · Answer

I tried recreating the problem and it works for me no problem. Having said that, I don't know how your data model is structured. It's possible you are trying to pass a filter from the many side to the one side.

Let me know if it's possible to share the pbix or you can also show the data model view.

v-juanli-msft · Answer

Hi&nbsp;Kolumam
Please check the following to let me know your situation better.
Do you use the default slicer?
Does your column added to the two silcer exsit in the same table?
How do you edit the interaction among these visuals in the same report page?
Is there any slicer on other page which this silcer is sync?
&nbsp;
Best Regards
Maggie

kolumam · Answer

Hi Anonymous,&nbsp;v-juanli-msft&nbsp;Thanks for your efforts. Please see below picto understand better. Unfortunately I don't have rights to share pbix. Let me know what other information you need.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;See the page level filter. When I remove the page level filter it shows LOI. If I put the page level filter to show only from April-18 to March-19, it disappears. So basically the field "Month" is in one table and "Phase" is in another table. I checked the relationships on how they are related. See the below pic when I clear the month filter.&nbsp;&nbsp;&nbsp;Month is basically present in a table called "Forecast Month"Phase is present in a table called "Projects"&nbsp;Basically, there is an indirect relationship between Projects and Forecast Month.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;I actually want the LOI to show even when the months are filtered as that could solve my issue. Let me know if you still need clarifications.

Forum Discussion

Filter not showing properly

7 Replies

Related content

Filters not working properly

Powerbi Component not showing data properly

Measure not filtering properly

Filter does not apply properly

Filter not working properly