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
Syndicate_Admin
Administrator
Administrator

Full month filtering in a table

Good

I am trying to filter a table by a specific month, I have created two filters one per year and one per month (attached photo), but in the table I am only taking the data for the day 01/02/2022, while my goal is to show me the sum for all days of the month of February 2022

Alberto99_0-1653379724669.png

1 REPLY 1
PC2790
Community Champion
Community Champion

Hey @Syndicate_Admin ,

 

Assuming you have a date table that is having relationship with your main table,you should only have Month and Year if you are interested in month wise view.

Something like this:

PC2790_1-1653381655756.png

And also, you need to pick the month and year from the date table to have a continuous view.

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.