radial gauge charts

[Raysaro]

Hi everyone,

Is there any possibility of creating a radial gauge chart with variable needles according to a specific filter? ex.: there is a filter for the city and each city has different targets. If city "RJ" is selected, the target is "10", but if city "SP" is selected, the target will be changed to "15".

I can not create a measure with the function "if" because it is only for numerical value and my first filter is a text.

Thanks

[v-luwang-msft · Accepted solution]

Hi @Raysaro ,

Refer the below:

You could download my pbix file to learn more details .

Did I answer your question? Mark my post as a solution!

Best Regards

Lucien

[Raysaro]

It worked!

Thank you so much!

[Seanan]

Hi @Raysaro 

Would you be able to share the table of data that you wish to use? 

*Update*

I believe using a calculated column with the following code will work

Target = SWITCH(TRUE(), 'Cities'[City] = "Test", 10, 'Cities'[City] = "Test1", 15, 'Cities'[City] = "Test2", 20)

You can then use a slicer to filter down between cities.