Set Custom Axis Power BI Sparkline

[LM24]

I have a table in Power BI set up with sparklines showing a how a rating (on a scale of 0 - 100) has changed over time by customer, however as each sparkline uses its own data to set the axis, the visual can be misleading.

For example, a customer going from 100 - 85 may not be a huge concern, however the sparkline shows it as a huge decrease as it considers 100 to be the max and 85 to be the min.

How do i set the axis to be max 100 and min 0 so that the sparkline visuals are more meaningful and not setting off unnecessary alarm bells?

[rajendraongole1]

Hi @LM24- sparklines in Power BI to have a fixed minimum and maximum value.

NormalizedRating =
DIVIDE(
[RatingMeasure] - 0,
100 - 0
)

Try the above measure and pass it measure value on y axis and date or required field on x axis.

Hope it works. Please check

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

[LM24]

Hi - Thank you, however I am unclear how to put your solution into my Power BI?