none
Mobile Reports Publisher - RAG RRS feed

  • Question

  • Hi,

    I have created a report using SSRS Mobile Reports Publisher.

    On the report I dragged a Number Gauge visual to show a basic measure (e.g value of 89%). Now I would like to change the colour of the gauge to red, amber or green using some thresholds.

    I seem to only be able to do this for a gauges that uses comparisons, is it not possible to do the above?

    This is a fundamental requirement (and a basic feature) for my report, without this we cannot proceed with using Microsoft Reports Publisher or SSRS Mobile Reports for our company.

    Surely there is a way to do this, right?

    Appreciate any help.

    Thanks

    Sunday, November 26, 2017 9:36 AM

Answers

  • I have found a workaround for this.

    1. In my dataset I include a field called 'DummyComparison' and set it's value to 1.

    2. In the report add a Gauage and in the data settings use the above field for comparison.

    3. In layout set Vizualization Type property to 'Full background'

    4. Configure range stop values

    5. Set Delta Label property to 'none'

     Not sure why Microsoft cannot simply add range stop values to the 'Number Gauge'.

    • Marked as answer by MSBIKB Sunday, November 26, 2017 11:57 AM
    Sunday, November 26, 2017 11:19 AM