Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
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
It worked!
Thank you so much!
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
96 | |
93 | |
82 | |
70 | |
64 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |