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.
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!
Solved! Go to Solution.
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.
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.
Best Regards,
Community Support Team _ Eason
Thank you very much for your speedy response I will feed this back to the template owner, much appreciated! 😉
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.
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.
Best Regards,
Community Support Team _ Eason
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
99 | |
99 | |
80 | |
77 | |
66 |
User | Count |
---|---|
134 | |
106 | |
105 | |
86 | |
72 |