Sliding Scale Visual

[Anonymous]

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 or right based on a measure's value:

Any ideas??

[MFelix · Accepted solution]

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

[Anonymous]

@MFelix This a great solution thanks! I will play around with it even further and see what I can come up with.

[v-lid-msft]

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]

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