How can I create Power BI visuals that change based on date comparisons e g YOY growth

0 votes
How can I create Power BI visuals that change based on date comparisons (e.g., YOY growth)?

 I’m working on a Power BI report that requires visuals to change dynamically based on date comparisons, such as Year-over-Year (YOY) growth. I need to ensure that the visuals correctly display comparisons for different time periods and adjust as the user interacts with the date filters.

How can I create Power BI visuals that change based on date comparisons like YOY growth?
Nov 19 in Power BI by Evanjalin
• 6,910 points
34 views

1 answer to this question.

0 votes

If you want to make visuals in Power BI that Adapt based on varying dates to compare, for example, growth rate over the years (YOY wise). Then do the following:

Prepare Your Date Table: The very first thing you need to do is ensure that there’s a complete date table in your data model. This table should have columns such as Year, Month, Quarter, and Day, among others. You can create this in Power BI using DAX, or you can import it into Power BI if you already have a data table. An adequate data table is very important for every time-related calculation using various intelligence functions.

Create the Necessary Measures: To illustrate the construct of a Yoy measure, one has to first understand how to create measures in DAX and the concept of context, enabling the measure to retrieve the current sense of the data within the given period. For example, in year-on-year growth calculation, suppose you want to present the sales figures of 2020 and 2021 as two figures on the Power BI tableaux.

Sales = SUM(Sales[Amount])

 Sales LY = CALCULATE(SUM(Sales[Amount]), SAMEPERIODLASTYEAR('Date'[Date]))

 YOY Growth = DIVIDE([Sales] - [Sales LY], [Sales LY], 0)

In this case:

Sales is the overall sales in the chosen timeframe.

Sales LY takes the sales from the corresponding time frame a year before using SAMEPERIODLASTYEAR.

YOY Growth determines the percentage difference when comparing this year’s growth vs last year’s growth.

Employ Time Intelligence Functions: Power BI provides many such time intelligence functions that increasingly simplify comparison calculations like YOY growth through functions like SAMEPERIODLASTYEAR, PARALLELPERIOD, and DATEADD. These assist in calculating figures for the same date the previous year or after a given time lapse.

Develop Dynamic Visuals: Incorporate appropriate visuals such as line graphs, bar graphs, or tables to present the measures that have been formulated. In addition, make sure that the pictures are linked with the time parameter so that they adapt quickly to the different time periods that the users of the data filtering or slicing have access to.

Dynamic Title = "YOY Growth for " & FORMAT(MIN('Date'[Year]), "YYYY") & " vs " & FORMAT(MIN('Date'[Year]) - 1, "YYYY")

The year chosen in the slicer determines this powerful title, which changes for the better context of the visuals.

Following these guidelines will help you build Power BI visuals that empower date comparison co-relations between different visuals, thus making time-oriented statistics análisis, such as year-on-year growth, more user-friendly.

answered Nov 19 by pooja
• 6,530 points

Related Questions In Power BI

0 votes
1 answer
0 votes
0 answers
0 votes
1 answer
0 votes
1 answer

Displaying Table Schema using Power BI with Azure IoT Hub

Answering your first question, Event Hubs are ...READ MORE

answered Aug 1, 2018 in IoT (Internet of Things) by nirvana
• 3,130 points
1,340 views
+1 vote
1 answer

Unable to install connector for Power Bi and PostgreSQL

I think the problem is not at ...READ MORE

answered Aug 22, 2018 in Power BI by nirvana
• 3,130 points
2,738 views
+2 votes
2 answers

Migrate power bi collection to power bi embedded

I agree with Kalgi, this method is ...READ MORE

answered Oct 11, 2018 in Power BI by Hannah
• 18,520 points
1,509 views
+1 vote
1 answer

Connect power bi desktop to dataset and create custom reports

Yes using Power BI REST API to ...READ MORE

answered Sep 18, 2018 in Power BI by Kalgi
• 52,350 points
1,658 views
0 votes
1 answer
0 votes
1 answer

How do I create custom tooltips that display different information based on the visual or data point in Power BI?

Designing personalized tooltips in Power BI is ...READ MORE

answered Nov 14 in Power BI by pooja
• 6,530 points
51 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP