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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
90 | |
89 | |
79 | |
70 | |
68 |
User | Count |
---|---|
226 | |
129 | |
120 | |
84 | |
78 |