cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Stuk Regular Visitor
Regular Visitor

Filter by Month my graphic

Hello everyone i have this graphic  Capture.PNGmade with those datas Capture1.PNGand i would like to class it month by month but advanced filter don't help me to do that, i don't know if it's useful but i have a calendar Capture2.PNG i have also tried this Capture3.PNG but it didn't worked do you have a solution? 

5 REPLIES 5
Super User
Super User

Re: Filter by Month my graphic

Yes a calendar is good. You need time intelligence. Read my articl ehere

http://exceleratorbi.com.au/dax-time-intelligence-beginners/

 



* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
Super User
Super User

Re: Filter by Month my graphic

Actually, maybe all you need I see a calendar table with a column called month.  For each date just have the month name and then use that's on your chart. 



* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
Stuk Regular Visitor
Regular Visitor

Re: Filter by Month my graphic

Thanks i tried this function Capture5.PNG "Dax comparaison don't take care about Text values with date values but i don't have any text values in my function, i'm using NombreCapture6.PNG  and the calendar the only text i have come from CT but i need it Capture7.PNG what can i do?

Stuk Regular Visitor
Regular Visitor

Re: Filter by Month my graphic

Other any solutions is welcome too

Moderator v-sihou-msft
Moderator

Re: Filter by Month my graphic

@Stuk

 

In this scenario, you already have a calendar table with date. To have to data group on month, you can add "Year-Month" and "Month Number" column in your calendar table. See: HOW TO CREATE A DATE TABLE IN POWER BI IN 2 SIMPLE STEPS

 

The issue mentioned in error message should be on "Date[Date].[Month]<=Max(Date[Date])". Don't use a month compare with a date directly. I'm not quite clear about your logic. It seems the comparison in your calculatioin filter should be on date level. It will be aggregate on Month level if you add those Month/Year-Month column as @MattAllington suggested. And if you want to compare month, it's better to use MONTH() function on date which returns integer values.

 

Regards,

 

 

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)