Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
yaabandoh
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 
1 ACCEPTED SOLUTION
Anonymous
Not applicable

@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.

View solution in original post

4 REPLIES 4
Anonymous
Not applicable

@yaabandoh  

Hey mate ,

You can use this .

 

Test = COUNTROWS(VALUES(Sheet1[Date]))test sample.JPG
 
Cheers 
Anonymous
Not applicable

@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.

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

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

And use the month column from the date table.

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors