Forum Discussion

sakshigrover's avatar
sakshigrover
Frequent Visitor
8 years ago

card visualization cross filtering with data table

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?

 

Need Help

3 Replies

  • v-piga-msft's avatar
    v-piga-msft
    Resident Rockstar
    8 years ago

    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

    • sakshigrover's avatar
      sakshigrover
      Frequent Visitor
      8 years ago

      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.

       

       

       

      • v-piga-msft's avatar
        v-piga-msft
        Resident Rockstar
        8 years ago

        Hi sakshigrover,

         

        I'm afraid that you are right.

         

        For your scenario, you could try to use Bookmark to achieve that.

         

        Best Regards,

        Cherry