I am hoping that somebody can help me. I've really got myself in a pickle and even applying logic doesn't seem to help.
I've got a report containing 4 slicers, 2 cards and 1 table which I need to interact with each other.
Slicer 1 contains: start date and end date (dd/mm/yyyy to dd/mm/yyyy).
Slicer 2 contains: event consultant (name field).
Slicer 3 contains: client name (list).
Slicer 4 contains: status (which is either, cancelled, confirmed or provisional).
Table 1: contains status, event consultant, client name, Business reference, start date, end date, commmission value and event value.
Card 1: Sum (£) of the commission --> which should be the same as the results of the table, which is filtered by the slicers.
Card 2: Sum (£) of the event value --> which should be the same as the results of the table, which is filtered by the slicers.
All of the slicers work together. Although the card results (which is a sum (£)) doesn't update when the slicers are altered. However, the table of data does.
Does anybody have any tips? I've tried to show what I am trying to achieve below. The arrows indicate what is impacted by the visual.
Hi @LeighMacKay ,
AFAIK, measures are calculated based on current row contents.
When you use them on card, their row contents will change to whole table and show the result of total table level.(it not able to expand detail records of each category)
I've added a small one minute video so that it "might" make what I am trying to achieve more achievable with a visual respresenation. As I understand that my initial post is not as clear as it possibly should well be.
I hope that this helps. Thanks again for viewing my post and trying to resolve my interactions issue.