Use a slicer to filter 2 month columns on the same table and display values on different cards

[Anonymous]

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

[v-chuncz-msft · Accepted solution]

@Anonymous,

You may refer to the following post.

https://community.powerbi.com/t5/Desktop/Create-a-Clustered-Column-Chart-using-Two-Summarize-Measures/m-p/340433#M152410

[Anonymous]

Thanks for your help, this did the trick!