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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
jeo
Regular Visitor

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.
Screenshot 2024-05-23 095622.pngThis is what the graph is currently showing.Screenshot 2024-05-24 084020.pngThis is what i want it to show

 

Regards,
Jeo

1 REPLY 1
amitchandak
Super User
Super User

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

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors