How to show values from a table in a scorecard when select a month from dropdown

[SantoshKumar]

Hi Guys,

I have a ask and it looks simple but not able to figure it out.

My table has three columns as shown in the figure below and i have expected show in the other snapshot.

In general, we have a show for Count of Column in Scorecard but my ask is to get the Individual value when we select any particular month. i took scorecard to show the value, in case if there is other option to choose is also fine.

I have attached the sample pwbi file also.

 DataExpected View

I have a Dropdown (Consist of Months) and 

[vivran22]

Hello @SantoshKumar,

It seems that the description you have provided is incomplete and few lines are missing.

What is the value you want to display in the datacard visual when you select a month?

Cheers!
Vivek

https://www.vivran.in/
Connect on LinkedIn

[SantoshKumar]

@vivran22 

When i select a Month. For example, if i select September then One Card should Show 10653 and other 162

when i select Sept and Oct then one card  should Show (10653+13535) and other (162+230) etc

Date	Col-A	Col-B
September-19	10653	162
October-19	13535	230
November-19	13083	488
December-19	11571	473
January-20	11054	458
February-20	9271	363

[vivran22 · Accepted solution]

@SantoshKumar 

This can be achieved throug simple selections:

sample dataset:

Select Sum from the datacard visual option

It will display the results accordingly:

Hope this is what you are looking for

Cheers!
Vivek

If it helps, please mark it as a solution
Kudos would be a cherry on the top 🙂

https://www.vivran.in/

Connect on LinkedIn

[amitchandak]

Select Card, In the visualization tab, right-click on your column and say sum, instead of count. If it Errors for the data type. Go to data data tab, click on column and change data type.