cancel
Showing results for
Did you mean:
Helper V

## Card Visualization

I have table with below type

And I want to create 3 seperate card visualizations like below screenshot

I added screenshot with exel sheet, I able to add above details to card group. but I need 3 separate cards . Is their anyway to complete that?

Do I need to add seperate query or measure ? I have no experience working with measures

1 ACCEPTED SOLUTION
Super User III

I'm not sure how you got the final values in your cards from the data you presented, but I'm guessing you are summing the values for x, y and z?

Here's a sample PBIX file

You can use a measure like this:

``````X =
CALCULATE(SUM('Cards'[Amount]), FILTER(Cards, Cards[Column] = "x"))``````

To give this

Regards

Phil

If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.

4 REPLIES 4
Super User IV

You Multi Row Card

Or you have to create three measures and use three cards

X= calculate(SUM('Table'[Amount]), FILTER(Table, Table[Column] = "x"))

Y= calculate(SUM('Table'[Amount]), FILTER(Table, Table[Column] = "y"))

Z= calculate(SUM('Table'[Amount]), FILTER(Table, Table[Column] = "z"))

Proud to be a Super User!

Helper V

Thanks for the solution, It seems like both solutions are same, I accepted preious answer, Because It replied first. Thank you for the understanding.

Super User III

I'm not sure how you got the final values in your cards from the data you presented, but I'm guessing you are summing the values for x, y and z?

Here's a sample PBIX file

You can use a measure like this:

``````X =
CALCULATE(SUM('Cards'[Amount]), FILTER(Cards, Cards[Column] = "x"))``````

To give this

Regards

Phil

If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.

Helper V

Thank you for the solution, Its worked as expectected.

Announcements

#### Happy New Year from Power BI

This is a must watch for a message from Power BI!