Forum Discussion
Rank Visual over time
Just an update on this theme of "inverting" Y Axis and the relevant workarounds for the benefit of others who might be looking for a similar solution.
The premise to the solution is to convert the rank number to a negative value by mutltiplying the rank * -1, and use this in a line visual. (The -1 will appear higher, since it is a larger value, while - 15 will be below). The problem is that displaying a negative value in the labels is clumsy and counter-intuitive for the end user of the report.
I did initially use the custom visual "Multiple Axes Chart" as suggested by Lin in this thread, but came across licensing issues and the fact that for some reason the label format in the chart seems to revert to default (with decimals) when published to my Workspace.
To cut a long story short, I actually had a bit of a revelation when I remembered that we can actually create custom formats for measures etc in Power Bi since "recently" (I did actually look for this originally but couldn't find the way to custom format numbers in the usual "Measure Tools" or visual formatting pane).
And yet it is available, albeit somewhat hidden, by going into the modeling section in Desktop, selecting the measure and "Fields" list and going into properties. This is where you CAN create your custom number format.
So I formatted my negative numbers to absolute number (got rid of the "-" symbol) and voilà!
So I can now use the default Line Chart visual to create my rank trend (with the stepped layout which I think is perfect for a rank trend: it resembles a podium) with the best rank on top/ worst rank below and without displaying the rank as a "negative" number. Just what I was looking for.
"Negative" numbers used to display rank
Hope this might be useful for others!
hi PaulDBrown
The problem is that the interaction is "Highlight" for this custopm visual default in your report.
Just change it to "Filter", then it will work well.
https://docs.microsoft.com/en-us/power-bi/service-reports-visual-interactions
Result:
BeforeAfter
Regards,
Lin
Good morning Lin. I can't believe I overlooked the interaction behaviour!!! (Now I feel really silly....)
Thanks again!!
Just an update on this theme of "inverting" Y Axis and the relevant workarounds for the benefit of others who might be looking for a similar solution.
The premise to the solution is to convert the rank number to a negative value by mutltiplying the rank * -1, and use this in a line visual. (The -1 will appear higher, since it is a larger value, while - 15 will be below). The problem is that displaying a negative value in the labels is clumsy and counter-intuitive for the end user of the report.
I did initially use the custom visual "Multiple Axes Chart" as suggested by Lin in this thread, but came across licensing issues and the fact that for some reason the label format in the chart seems to revert to default (with decimals) when published to my Workspace.
To cut a long story short, I actually had a bit of a revelation when I remembered that we can actually create custom formats for measures etc in Power Bi since "recently" (I did actually look for this originally but couldn't find the way to custom format numbers in the usual "Measure Tools" or visual formatting pane).
And yet it is available, albeit somewhat hidden, by going into the modeling section in Desktop, selecting the measure and "Fields" list and going into properties. This is where you CAN create your custom number format.
So I formatted my negative numbers to absolute number (got rid of the "-" symbol) and voilà!
So I can now use the default Line Chart visual to create my rank trend (with the stepped layout which I think is perfect for a rank trend: it resembles a podium) with the best rank on top/ worst rank below and without displaying the rank as a "negative" number. Just what I was looking for.
"Negative" numbers used to display rank
Hope this might be useful for others!