Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello everyone!
my first post around here. I've started to practice a few things with PowerBI desktop and a doubt came to my mind based in something I'm trying to do.
I have a table that looks like this in my data (simplified for the sake of the example):
I then created a Dates table (using the calendar function) to populate a slicer with Months (don't know if it's the best way to do it but it seems to work). What I want to achieve, is to display two different cards, with the values filtered based on what is selected in the slicer:
1st card. Count of created tickets, filtering Month Created by the month that is selected in the slicer
2nd card. Count of closed tickets, filtering Month Closed by the month that is selected in the slicer
Tried many things but can't seem to find a way of filtering this at the card filter level.
Thanks in advanced!
Juan
Solved! Go to Solution.
@Anonymous,
You may refer to the following post.
@Anonymous,
You may refer to the following post.
Thanks for your help, this did the trick!
User | Count |
---|---|
100 | |
87 | |
81 | |
76 | |
71 |
User | Count |
---|---|
113 | |
104 | |
100 | |
73 | |
65 |