Filter Interactions

[gdps_vc]

Greetings everyone!

A little context before I describe my problem:

I have 2 tables in my model, that are related by a date column (*:1)

1) CalendarTab with dates until the end of 2025
2) ChamadosCSC, with a list of incidents.

Some incidents can impact my team, so there is the column "Impacto Time" = 1, when this occurs, in the table ChamadosCSC.

I created a measure to get the number of incidents that impact my team and also a measure to get the % of these incidents in relation to the total.

But my problems start when I try to create the visuals:

In the second visual, what can I do to hide the months from Mar onwards? I know I could put in a filter and select only the months of Jan and Feb, but is there anything more automatic?

And another problem I encountered was that when I clicked on the graph to filter a month:

Is there any way to keep the Jan month column displaying the correct value?

Best Regards

[Anonymous]

Hi @gdps_vc 

Can you provide detailed sample pbix file and the results you expect.So that I can help you better. Please remove any sensitive data in advance.

Best Regards,

Jayleny

[gdps_vc]

First problem solved. I discovered that my CalendarTab has an offset column, where current month = 0, previous month = -1 ...

So I filtered the model to display offset <= 0

[PijushRoy]

HI @gdps_vc 

Can you please share measure using in below yellow highlighted visual

[gdps_vc]

Sure @PijushRoy 

CSC_Eficiencia = 
1 - DIVIDE(
    [CSC_Qntd_Chamados_Time],
    [CSC_Qntd_Chamados],
    0
)