Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Team, any support is helpful. How can I show a percentage increase with multiple charts on the same value on the X-axis? I have not shown the X-axis. Basically, it has a supplier, and each supplier has a growth rate of multiple years. Four graphs show Years W, X, Y, and Z for supplier A. The growth from 3.8 to 5.1 is 33%. It is always between the first year and the last year (W and Z in this case).
Solved! Go to Solution.
Hi @lotus22 ,
I'm not sure I'm understanding you correctly. I think you are trying to show these three percentage numbers in this chart?
But it's unlikely that you'll be able to implement this format in this visual object:
I recommend that you use this visual object:
And use this DAX to create a measure:
Measure =
VAR _maxyear =
CALCULATE(
MAX('Table'[Year]),
ALL('Table')
)
VAR _minyear =
CALCULATE(
MIN('Table'[Year]),
ALL('Table')
)
VAR _max =
CALCULATE(
SUM('Table'[Value]),
ALLEXCEPT('Table', 'Table'[Type]),
'Table'[Year] = _maxyear
)
VAR _min =
CALCULATE(
SUM('Table'[Value]),
ALLEXCEPT('Table', 'Table'[Type]),
'Table'[Year] =
_minyear
)
RETURN
(_max - _min) / _min
Create the visual and the final output is as below (I changed the font color of the data labels for clarity) :
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @lotus22 ,
I'm not sure I'm understanding you correctly. I think you are trying to show these three percentage numbers in this chart?
But it's unlikely that you'll be able to implement this format in this visual object:
I recommend that you use this visual object:
And use this DAX to create a measure:
Measure =
VAR _maxyear =
CALCULATE(
MAX('Table'[Year]),
ALL('Table')
)
VAR _minyear =
CALCULATE(
MIN('Table'[Year]),
ALL('Table')
)
VAR _max =
CALCULATE(
SUM('Table'[Value]),
ALLEXCEPT('Table', 'Table'[Type]),
'Table'[Year] = _maxyear
)
VAR _min =
CALCULATE(
SUM('Table'[Value]),
ALLEXCEPT('Table', 'Table'[Type]),
'Table'[Year] =
_minyear
)
RETURN
(_max - _min) / _min
Create the visual and the final output is as below (I changed the font color of the data labels for clarity) :
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
85 | |
67 |