cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper V
Helper V

Card Visualization

I have table with below type

Dilantha_0-1606801897579.png

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

Dilantha_1-1606801954717.png

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

 

Thank you in advance. 

1 ACCEPTED SOLUTION
Super User III
Super User III

Hi @Dilantha 

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

cards-sums.png

Regards

Phil


If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.

View solution in original post

4 REPLIES 4
Super User IV
Super User IV

@Dilantha ,

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"))

 

 



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

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
Super User III

Hi @Dilantha 

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

cards-sums.png

Regards

Phil


If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.

View solution in original post

Thank you for the solution, Its worked as expectected.

Helpful resources

Announcements
secondImage

Happy New Year from Power BI

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

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors