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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Kingfisher1
New Member

Filter MonthName showing days per month and year?

Hi,

 

I use a Power BI report set up by another user, they claim that the figures listed to the right of the MonthName in the filters are not the month/year day count. I understand they are, can you clarify please. Screenshot attached FYI. Many thanks for your help! Month Year Day Count Query.PNG

1 ACCEPTED SOLUTION
v-easonf-msft
Community Support
Community Support

Hi, @Kingfisher1 

Yes, the figures listed to the right of the MonthName in the filters are the counts of recorded values in current table.

You can do a test like this, change the summary type of the field in the table to 'Count' and you will find that these values will match those in filter pane.

veasonfmsft_0-1653012358076.png

It should be noted that from the screenshot you provided, ‘MonthName' should be a field in the 'Fact Table' and 'Year' should be a field in another 'Date Table'.

Since the total number of records in the two tables is inconsistent, the total number of records for all values in filters is naturally inconsistent.

veasonfmsft_2-1653013325415.png

 

Best Regards,
Community Support Team _ Eason

View solution in original post

2 REPLIES 2
Kingfisher1
New Member

Thank you very much for your speedy response I will feed this back to the template owner, much appreciated! 😉

v-easonf-msft
Community Support
Community Support

Hi, @Kingfisher1 

Yes, the figures listed to the right of the MonthName in the filters are the counts of recorded values in current table.

You can do a test like this, change the summary type of the field in the table to 'Count' and you will find that these values will match those in filter pane.

veasonfmsft_0-1653012358076.png

It should be noted that from the screenshot you provided, ‘MonthName' should be a field in the 'Fact Table' and 'Year' should be a field in another 'Date Table'.

Since the total number of records in the two tables is inconsistent, the total number of records for all values in filters is naturally inconsistent.

veasonfmsft_2-1653013325415.png

 

Best Regards,
Community Support Team _ Eason

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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