Forum Discussion

jeo's avatar
jeo
Regular Visitor
2 years ago

How do i show a month data and a year data in the same graph?

Hi all,   I want to put a data for monthly and a data for yearly i the same line grah. The yearly data will be divided by the number of months which is wrong. This is what the graph is current...
Need Help
Tutorial Requests
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
2 years ago

jeo , Ideally you should use removefilter of all to make monthly data yearly

 

example

calculate([Meausre], removefilters(date[Month])

 

or

example

calculate(Averagex(Values(Date[Month Year]), [Meausre]) , removefilters(date[Month])

 

You can put logic to show value only in June

 

If( Month(Max(Date[Date]) ) =6, calculate(Averagex(Values(Date[Month Year]), [Meausre]) , removefilters(date[Month]), blank() )