Forum Discussion
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
- PijushRoyCommunity Champion
HI Anonymous
Can you please share measure using in below yellow highlighted visual- AnonymousNot applicable
- AnonymousNot 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
- AnonymousNot 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