Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I am working on a report in which I need to create a Card visualization showing number of Active Events.
I also have a Table that has details of Events. I need the ability to cross filter on Table on clicking on Card.
Basically, on click of Card I need to see all the events with ReviewStatus as Active.
Any clues?
Hi @sakshigrover,
It seems that you want to calculate the count of active Event.
Please refer to the fomula below.
Measure = CALCULATE(COUNT(Table1[status]),FILTER('Table1','Table1'[status]="Active"))
If you still need help, please share some data sample and your desired output.
Best Regards,
Cherry
My Requirement is like this:
I need to show number of Active Events in the report. I am already able to do that using a measure.
I also have a table in my report which shows the event details ( like Event ID, Event name etc.).
What I need is on click of Active event card, the Event Details table gets filtered.
I underrstand that card doesn't have filtering. Am I right?
If above is correct, then visually how should I show Active events count and on click of that event details table is also filtered.
Hi @sakshigrover,
I'm afraid that you are right.
For your scenario, you could try to use Bookmark to achieve that.
Best Regards,
Cherry
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |