Forum Discussion
Show Data on Card Based on Status
- 6 years ago
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/823601 - 6 years ago
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:
Best Regards,
Giotto Zhi
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/823601