Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
I have a Dropdown (Consist of Months) and
Solved! Go to Solution.
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
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
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 |
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
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.
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
114 | |
97 | |
95 | |
68 | |
65 |