Forum Discussion
Gauge visual
I have 3 coulumns 1.name 2.value(%) 3.Months. i want to display the values in guage visual where the target should be set manually.
Task: When i select a particular name and month from slicer , the guage should show the particular value.
min:0 max: 100% target(manually): 30%. kindly help me out with the solution.
5 Replies
- amitchandakSuper User
You can create a what-if parameter with intial value as 30 and use it
https://docs.microsoft.com/en-us/power-bi/desktop-what-if
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-radial-gauge-charts
https://data-flair.training/blogs/power-bi-radial-gauge-chart/
- ghouse_peerPost Patron
Hello amitchandak
The links u provided, i have already gone through it. It is not helping me.
Actually i have only 1 value column that contains percentage values, with that one column itself i need to do calculation. Parameter is not working. Any other way out kindly let me know.
- ghouse_peerPost Patron
Hello amitchandak
As per the links, i am getting the values correctly, But target is not getting displayed in visual.
For ex: When i select Name and month from slicer , The gauge shows only particular values accordingly but i cannot see target value in visual. Kindly help me out with this.
- amitchandakSuper User
ghouse_peer , can share some sample data in table format and some drawing of what you need