cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

Count Date

Please I need help: I want to show that number of products that were relaunched in a particular month. I want to display this on a bar chart with my x-axis as the month-year, with the bar showing the number of products relaunched. There are some products that were not relaunched, and some months where no product was relaunched. Below is a sample Table:

Product CodeDateDate Relaunched
A17/1/2020 
B17/1/202010/15/2019
C17/1/20209/24/2019
A27/1/202010/4/2019
B27/1/202010/3/2019
C27/1/20205/29/2020
A37/1/20209/26/2019
B37/1/2020 
C37/1/20205/29/2020
A47/1/20209/24/2019
B47/1/20206/18/2020
C47/1/20206/18/2020
A18/1/2020 
B18/1/2020 
C18/1/2020 
A28/1/2020 
B28/1/2020 
C28/1/2020 
A38/1/2020 
B38/1/2020 
C38/1/2020 
A48/1/2020 
B48/1/2020 
C48/1/2020 
4 REPLIES 4
Resolver II
Resolver II

@yaabandoh  

Hey mate ,

You can use this .

 

Test = COUNTROWS(VALUES(Sheet1[Date]))test sample.JPG
 
Cheers 
Super User II
Super User II

@yaabandoh  Yu can create a measure like below-

Products Relaunched = CALCULATE(COUNT('Table'[Product Code]),FILTER('Table','Table'[Date Relaunched]<>BLANK()))
 
And your visualization would look like this- 
 
 
 

BarChart.PNG

 

Appreciate your kudos!! Please accept this post as solution if it helps.


Nikhil
Hit the Thumbs-up button if you find this informative!!
Did I answer your question? Mark my post as a solution!


Proud to be a Super User!

@NikhilKumar Thank you. Please I will like the graph to show bars for all the months, with 0 values for where there is no relaunch.

@yaabandoh Create a date table and make a relationship with the data table.

And use the month column from the date table.

 


Nikhil
Hit the Thumbs-up button if you find this informative!!
Did I answer your question? Mark my post as a solution!


Proud to be a Super User!

Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Wave Release 2

Check out the updates in Power BI.

Overview of Power BI 2020 release wave 2!

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.