Forum Discussion
AdministratorUse multiple cards with multiple filters
Good community. I have the following query, on the same sheet I need to have two cards, where each one has a different date filter. Example amount of inputs that entered from 1 to 7 and amount of inputs that graduated from 1 to 7, in these cases I have two fields, date of entry and date of discharge. It gets complicated for me with date filters since only one of the dates takes me.
Greetings to all.
4 Replies
- amitchandak
Super User
Syndicate_Admin , I think interactions should help
How Interactions Work- Split Page using interactions to compare: https://youtu.be/GIfRKzhMaR4
or
How to use two Date/Period slicers :https://www.youtube.com/watch?v=WSeZr_-MiTg
Hi Syndicate_Admin ,
What does the 1-7 stand for? The date day of [date of entry] and [date of discharge], ike 2021/10/1 -2021/10/7?
And did you create parameter for display 1-7?
Count of entry = CALCULATE(COUNTROWS('Date'), FILTER('Date', DAY('Date'[date of entry])>=MIN('Parameter'[Parameter]) && DAY('Date'[date of entry])<=MAX('Parameter'[Parameter])))Count of discharge = CALCULATE(COUNTROWS('Date'), FILTER('Date', DAY('Date'[date of discharge])>=MIN('Parameter'[Parameter]) && DAY('Date'[date of discharge])<=MAX('Parameter'[Parameter])))If it isn't your expected, please share more detail information to help us clarify your scenario,refer to:
How to provide sample data in the Power BI Forum - Microsoft Power BI Community
How to Get Your Question Answered Quickly - Microsoft Power BI Community
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.- hashtag_pete
Helper V
Hello Syndicate_Admin
when you have to slicers, you can use the interaction to define which slicer works on which card visual, please see following screenshot.
Does that help? If so, please
• mark this post as a solution
• give kudos
Thanks hashtag_pete Hi Syndicate_Admin ,
Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution to make the thread closed. More people will benefit from it.
Best Regards,
Eyelyn Qin
