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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
fabiomanniti
Helper III
Helper III

Filter until date: month by month

I want to make a "month by month" filter but if I use the date hierarchy I can see the situation only in that month and not until that month.

I can use a date filter using "Before" but in this way I can discretize only day by day and not month my month.

 

I'll explain better:
I want to know who sold more product so far: I make a chart ordering by "Product sales" and I take the first one.

If I want to know who was the first last month I can use this filter 

fabiomanniti_0-1643195508988.png

 

and I see what happened until the selected date.

 

This works but I don't like because it goes day by day and I would like it month by month.

How can it be possible?

Thank you

1 ACCEPTED SOLUTION
1 REPLY 1
amitchandak
Super User
Super User

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

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.