Forum Discussion
card visual - query
Is there any way I can get the displayed data on the card visual?
My problem is I have two card visuals. I cannot use a multi row card as the two cards are acted upon by different slicers (some don't interact with one visual). So, though the underlying data is the same, the visuals show data based on different criteria and hence cannot be on the same visual.
I am trying to get the % difference between the displayed data in the two cards. Any help is appreciated
-Prasad
7 Replies
- Just create a measure that does the same aggregation as the Card visual. So if the card visual sums 'Table'[Column],
Measure = SUM('Table'[Column]) pvenkat ,
Could you please share some sample data and clarify more details about your requirement?
Regards,
Jimmy Tao
Here is a test data set for what I am trying to build with:
Date Route Time Clean Time Clean Time - Route Time Inspection Time Inspect - Clean Time Vert Surfaces Horiz Surfaces Final Scores 3/16/2020 9:00 9:01 1 9:15 14 1 1 1.0 3/23/2020 9:00 9:05 5 11:16 131 4 5 4.7 3/30/2020 9:00 9:20 20 10:00 40 1 3 1.8 4/6/2020 9:00 8:50 9 11:16 146 4 5 4.7 4/13/2020 2:00 2:18 18 2:45 27 1 2 1.3 4/20/2020 2:00 2:40 40 4:20 100 3 5 4.0
