Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Filter Interactions

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

4 Replies

  • PijushRoy's avatar
    PijushRoy
    Community Champion

    HI Anonymous 

    Can you please share measure using in below yellow highlighted visual

     

    • Anonymous's avatar
      Anonymous
      Not applicable

      Sure PijushRoy 

       

      CSC_Eficiencia = 
      1 - DIVIDE(
          [CSC_Qntd_Chamados_Time],
          [CSC_Qntd_Chamados],
          0
      )
  • Anonymous's avatar
    Anonymous
    Not applicable

    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

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Anonymous 

     

    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