I am new to power BI.
I am just tyring to to do a running totals on quarters for different years. I am using QTD formula.
The output somehow is not reflecting Running totals by quarters.
Solved! Go to Solution.
not sure what you mean by endoutput? you mean excel table?
output is going to be same as we discussed, its just that i am not able to translate the data into desired graph.
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Please show the expected outcome based on the sample data you provided.
Thanks for your response, I had almost given up on expecting a response, cuz this is my first query on this forum.
I have attached my file here. THis is google drive link, hope you can access it.
let me rephrase my query. I would like to have separate lines for each quarter year. it works fine for the years YEARLY RUNNIN SALES tab in the attached file.
I attempted to do the same in QTD SALES GRAPH NOT WORKING tab but to no avail. In short I would like to replicate the YEARLY RUNNIN SALES tab except I need quarters here (as separate lines) not years
Thank you for your time.
and calendar date table Mark as Date table >> right click on table >> select calendar date >>set as date >> see below screen shot
Thank you Mahesh for looking into this, however this is not what I am after. I am trying to replicate the graph as shown in the image. I need running quarterly sales for each line. each line denotes a different quarter. eg (one line for current quarter, one for previous quarter current year, another for current quarter last year. I was able to create this chart by years but stuck with quarterly approach. Thank you.
@san17680 i think you should remove legend for In short I would like to replicate the YEARLY RUNNIN SALES tab except I need quarters here (as separate lines) not years.
How Do i show these quarters as separate lines in the graph as shown in the image I shared in the previous post? this is where I am struggling.
this does the trick. thank you so much Mahesh. I have marked this as solution. Just one last thing is there a way to fit ths graph so that I dont have to scroll all the way to right.