Forum Discussion
Show Data on Card Based on Status
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.
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-with-Winners/ba-p/890814
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p/881739
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601Hi,
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:
Best Regards,
Giotto Zhi
2 Replies
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-with-Winners/ba-p/890814
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p/881739
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601Hi,
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:
Best Regards,
Giotto Zhi