Data filter only shows "Select all"

[gustalem]

Hello,

In a dashboard i'd using for a years, has a some product's data filters.When I filter this month, the are no options to filter on those data filters (only "Select All"), but when the month filtered is one previously, it has.
In both cases, the other things which are filtering the object are the same.

I can't found anything else diferent other than the date. I'm sure the month which the filter isn´t working, has data to show in this filter. 

Anyone can help me?

Thank you!

[Anonymous]

Hi @gustalem ,

Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

[gustalem]

I can't share my pbix, but I can show some captures. 

For example, en left, División has no option, but in the matrix, you can see there're options availables in April.

In march the filters is working, you can see there're options to select. Is the same filter, and nothing else has been change between the photos, only the month filtered. 

Let me know if is enough to understand the problem!

Thank you in advance for your help!

[Anonymous]

HI @gustalem,

Have you turn on the 'interactions' layout to modify the visual interactions? AFAIK, they may affect the visual filter and interactions.

Change how visuals interact in a report - Power BI | Microsoft Learn

BTW, Dax filter effect are based on these interactions. If you turn off the interaction between filter and visuals, Dax expression should not able to extract the filter effects and apply filter contents to the expression.

Regards,

Xiaoxin Sheng

[gustalem]

Thank for your answer again, and I've already know how visual interact each other, I checked it, and the problem keeps.

I'll show the data model:

The only thing used in the next images, are: Calendario (Calendar), Ventas Totales (Sales), and Productos (Product).

There's any aditional filter, and the only thing is: Data filter for Month Year, Data Filter for División, and bar graph for total sales by division.

When I filter March 2024 (or anymonth before), the Data filter for Division has options, and is showed in the graph.
When I filter April 2024, all the options for Division dissapear, but as you can see in the bar, for Apil there're data available for division.

I don't know how to fix it, i've tried everything.