Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Sliding Scale Visual

Hi Guys,   Does anybody know if there is an existing sliding scale visual as shown in the image below? Or maybe there is a trick that can be used to achieve this. Ideally the arrow would shift left...
Need Help
  • MFelix's avatar
    MFelix
    6 years ago

    Hi Anonymous ,

     

    One option can be to make 3 different visuals:

     

    - Bar chart for the category

    - Scatter char for the shape

    - Card for the value

     

    Create a table with the Category data:

     

    Category      ID

    Initial 1
    Repeatable 2
    Defined 3
    MAnaged 4
    Optimized 5

     

    The compose your visualization based on the following

    Bar chart:

    • Axis: Category
    • Value: Sum ID
    • Change colours
    • Data Labels on inside end
    • Adjust the Category width, and inner padding to put bar together
    • Turn off Y axys

    Scatter chart:

    • X-Axis - Column or measure that you want to have highlited
    • Make the X-axis with minimum and maximum value from1 to 6 (or other as fits you calculations)
    • Change the Shape to whatever you would like ( my case a triangle) and make it a big size in preference
    • Adjust the dimension of the scatter chart X-axis so that the number align with the spaces between the bars of the bar chart
    • Turn off bar x-axis

    Create a Card with the measure that you want to have value.

    Group all of the elements final result below and in attach file.

    Be aware that if you place the scatter chart and card above the bar chart you need to turn off the background.

     

     

     

     

    Hope thi helps to give you an idea about how you can do it without any custom visuals. Only just some ideas.

     

    Regards,

    MFelix

v-lid-msft's avatar
v-lid-msft
Community Support
6 years ago

Hi Anonymous ,

 

Sorry for that, but I also not found an effective solution to achieve your requirement, perhaps you can submit the requirement to ideas and add your comments there to make this feature coming sooner : https://ideas.powerbi.com/forums/265200-power-bi-ideas

 

you could also create your own custom visual if is an experienced web developer: https://powerbi.microsoft.com/en-us/documentation/powerbi-custom-visuals/

 

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi v-lid-msft ,

 

Thanks for your feedback. I will submit it to the ideas forum, I was hoping there might already but something that I was just not able to find.

 

I will look into creating it as a custom visual, and will post it here if I am able to build an elegant solution.

 

Thanks,

Elmar