Need help to create new record based on YOY Growth in Table visualization

[satishorre20]

Greetings,

I am trying to find the solution to create a Growth record using current year and prior year information shown in the excel table below. The data is aggregated by each day in the data model and don't have a record growth record in the model. I can show Growth measure as a column in Table Visualization, but I wanted to see the growth record in the visuliazaiton. 

Model :

Date Dimension

Sales Fact grain is  one record per day

Do you have any thoughts on this?

Thank you for your time on this.

Sample Data format:

	Sales  mtd	Cost MTD
15-May-2025	50	100
15-May-2024	40	60
Growth ( Current year- prior year)	10	40

[satishorre20]

Hi @maruthisp / @tharunkumarRTK 

Thank you for the quick response on my question and sorry for the delay in response.  disconnected table will work, but I was looking for to have a measure to calculate growth without adding table or new measure and see if any feature is available with in the visualization to have difference between two rows instead Grand total in the table visualization.

[v-sgandrathi]

Hi @satishorre20,

Has your issue been resolved?If the response provided by the community member addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone.

If yes, kindly accept the useful reply as a solution and give us Kudos. It would be appreciated.

Thank you for your understanding!

[v-sgandrathi]

Hi @satishorre20,

May I ask if you have gotten this issue resolved?

If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.

Thank you.

[v-sgandrathi]

Hi  @satishorre20,

We wanted to follow up since we haven't heard back from you regarding our last response. We hope your issue has been resolved.

If my answer resolved your query, please mark it as "Accept Answer" and give Kudos if it was helpful.

If you need any further assistance, feel free to reach out.

Thank you for being a valued member of the Microsoft Fabric Community Forum!

[maruthisp · Accepted solution]

Hi satishorre20,

As per my understanding, you can create a disconnected table with values like - Current Year, Previous Year, Growth.

YOY Growth.pbix
I implemented the solution in the below attached pbix file, please check it and let me know if you have any questions.

If this reply helped solve your problem, please consider clicking "Accept as Solution" so others can benefit too. And if you found it useful, a quick "Kudos" is always appreciated, thanks! 

Best Regards, 

Maruthi 

LinkedIn - http://www.linkedin.com/in/maruthi-siva-prasad/ 

X            -  Maruthi Siva Prasad - (@MaruthiSP) / X

[tharunkumarRTK]

@satishorre20 

Can you share few more details?
As per my understanding you want to show the same growth numbers in any other visual other than table, is it?

if you want to see the same numbers with the same granularity then

(I am assuming your growth measure was written correctly, if not then follow this: https://www.sqlbi.com/articles/custom-year-over-year-calculation-in-dax/ )

place the date column  in x axis and growth measure in Y axis. 

For further help, Please the PBIX file and replace your data with some sample data and share you expecation. 

Need a Power BI Consultation? Hire me on Upwork

Connect on LinkedIn

Did I answer your question? Mark my post as a solution!
If I helped you, click on the Thumbs Up to give Kudos. Proud to be a Super User!