Recently I was working on Gauges design and I had to display %Ratio of the % column in gauges. It looks straight forward requirement but could not find out a way to change % display on scales to data values easily.
searched google/helps, but could not solve it. My % Ratio column shows %of total in scales which makes no sense for the user to analyze it.
- This is what being displayed at first when you pull the column in the Gauges view.
2. I thought there will be an option available in properties to change the % values to actual values. Tried multiple options under Layout/Settings but no change on the scales, yet :-(
3. Then I clicked on Edit Gauge Properties Properties and looked at all the options. Went through all the options like Style, Scale, Titles and Labels but no luck.
4. Did I miss something? Well, Yes. Going through the options again, I show options called Scale Labels in Titles and Labels. Initially I thought it would be only for the formatting of the scale.
Along with options of Font/Number Format, this also gives you an option of "Display Options". Here I could change Scale Labels to Actual Values instead of Default (Percentage of Total)
5. After making this change, I could achieve my guage layout as expected. Wow, there was no bug :-). I feel, placement of this option should be placed at the first tab under Gauge properties :-).
Cheers...
