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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Syndicate_Admin
Administrator
Administrator

compare the total of one month to the previous month on the same dashboard

Hello I want to make a visual that shows the total and on the same dashboard reflect the percentage of increase or decrease compared to the previous month, if it can not be percentage, with numerical value showing the variation I am worth

8 REPLIES 8
Syndicate_Admin
Administrator
Administrator

Hello, I had more urgent things to finish and I still have this doubt pending, I do not know if you would still have availability to review a file if I share it around here?

Sure!

v-shex-msft
Community Support
Community Support

Hi @Anonymous,

Can please share some dummy data with a similar data structure and expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
rwaanders
Frequent Visitor

You can try something like:

 

compare =

VAR current = CALCULATE(SUM(Table[Column]))
VAR previous = CALCULATE(SUM(Table[Column]),DATEADD([Datetable[Date],-1,MONTH))
RETURN
(current-previous)/previous

*****

If you add a graph with months from 1 to 12, the current calculation will return the amounts for those periodes. The previous calculation will returns the amount from period 11 at period 12 (so the previous month).

You can then easily calculate the % by calculation "new value minus old value divided by old value".

Make sure to mark the measure as percentage.

thank you for the answer, I actually have to represent in a graph the number of employees per department and that the same graph in each department with a different color can be seen visually if that month the number of employees has increased or decreased

Is it possible to share the PBIX file or to generate a sample PBIX file in which the measure can be added?

I can create an example and share it, it's employee information so the original I can't share

Please let me know when it's ready, then I'll add the measure.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.