Forum Discussion
Set Custom Axis Power BI Sparkline
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?
2 Replies
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!!- Hi - Thank you, however I am unclear how to put your solution into my Power BI?
