cancel
Showing results for
Did you mean:

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

## 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

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?

Frequent Visitor

Sure!

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.

Regards,

Xiaoxin Sheng

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

You can try something like:

compare =

VAR current = CALCULATE(SUM(Table[Column]))
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

Frequent Visitor

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

Frequent Visitor

Announcements

#### New forum boards available in Real-Time Intelligence.

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

#### Power BI Monthly Update - May 2024

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

#### Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors