How to change the Card Display with Slicer Selection .

[Anonymous]

Hi Team,

I have a database with Columns CustomerName, Status, BidPrice and Quantity..

In Status i have Won, PartialWin, Open.

The Customer name and Status is on Slicers..

If i Select a Customer in Customer Name Slicer(without Selecting Status Slicer) then,

I have to display a four Cards

1.  Won = (Won tenders Bidprice)* (Won Tenders Quantity) in a card

2.  PartialWin = (PartialWin tenders Bidprice)* (PartialWin Tenders Quantity) in another card

3.  Open = (Open tenders Bidprice)* (Open Tenders Quantity) in another card

4. Total Amount = Won + PartialWin + Open in another Card

Now the Client is asking me to display that,

If they select Won in Slicer Status(without Selecting Customer Name Slicer) then only won Card will be shown and remaining Open and PartialWin as Blank.

If they Select PartialWin in Slicer Status(without Selecting Customer Name Slicer) then only PartilaWin Card will be shown and remaining Open and Won as Blank.

If they Select Open in Slicer Status(without Selecting Customer Name Slicer) then only PartilaWin Card will be shown and remaining PartialWin and Won as Blank.

Please Help me Out.

Thanks & Regards,

Kishore Babu P.

[dax · Accepted solution]

Hi krrish116,

You could refer to my sample to see whether it work or not.

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi,

You are Amazing Zoe Zhi..

Thanks for the Quick Help..

Regards,

Kishore .