cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
lakshnajha Frequent Visitor
Frequent Visitor

visualization monthly - need help

hi

i have data by date and need to summarize monthly to show on bar chart

i had seen before an option where i could select on my createdat filed as monthly but now i dont see it

pls help

 

 

2016-01-20.png

1 REPLY 1
greggyb New Contributor
New Contributor

Re: visualization monthly - need help

You can create a month field in your date dimension, and should do so anyway:

 

// Power Query
MonthNumber =
Date.Month( [Date] )

MonthName =
Date.ToText( [Date], "MMMM" )

MonthNameShort =
Date.ToText( [Date], "MMM" )


// DAX
MonthNumber =
MONTH( DimDate[Date] )

MonthName =
FORMAT( DimDate[Date], "MMMM" )

MonthNameShort =
FORMAT( DimDate[Date], "MMM" )

Helpful resources

Announcements
GregDeckler

How to Get Your Question Answered Quickly

Power BI Super User, Greg Deckler, explains

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Ideas
Users Online
Currently online: 42 members 946 guests
Please welcome our newest community members: