Show Data on Card Based on Status

[hilmandenis]

Hi everyone,

I have a canvas that shows a report of a transaction. It's something like this

I want to create a card that shows a summarize value of Pay Amount based on Order Status if I click the date in the line chart. Right now both are showing the total amount based on date. I want the left card to show the total Pay Amount of the successful order and the right card to shows the total Pay Amount of fail order. 

[amitchandak · Accepted solution]

In Visual level filter, you can add order status and filter

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/Winner-Topper-on-Map-How-to-Color-States-on-a-Map-wi...
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p...
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601

[v-gizhi-msft · Accepted solution]

Hi,

According to your description, I create a table to test:

Then, I create two measures to calculate Sum of [Pay Amount] based on [order Status]:

Successful Sum = CALCULATE(SUM('Table'[Pay Amount]),FILTER('Table','Table'[Order Status]="Successful"))

Failed Sum = CALCULATE(SUM('Table'[Pay Amount]),FILTER('Table','Table'[Order Status]="Failed"))

Choose the card visual for these two measures and choose date as a slicer, the result shows:

Here is my test pbix file:

pbix 

Best Regards,

Giotto Zhi

[amitchandak · Accepted solution]

In Visual level filter, you can add order status and filter

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/Winner-Topper-on-Map-How-to-Color-States-on-a-Map-wi...
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p...
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601