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 currently showing.This is what i want it to show

 

Regards,
Jeo

Need Help
Tutorial Requests

1 Reply

  • 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() )