Forum Discussion
Graph for ranges
Hi Muhammad_Wasif , You need only one graph the incentive graph or the colorful graph ?
Regards,
Nikhil Chenna
Hi Nikhil,
I want both Graph Colourful graph is based on sales number and there is a max range and min range each vendor sales number is shown in graph falling between min to max range, vendor5 sales exceed the max range which is shown in graph as well. Based on sales number in table2 incentive percentage is a caculated colum which takes value of sales multiply by incentive% ( this percentage depend on the min range and max range where the sales value fall) and incentive graph is based on this calculated column. i also want to know how can i add this calculated column as well.
Hi Muhammad_Wasif ,
You can achieve both in one bar graph only.
1. Plot the second graph which is Vendor wise Incentives.
2. Go to the Conditional formatting and apply condition and you'll get the color on the bars.
You can take try the solution from the below references too,
https://community.powerbi.com/t5/Desktop/Color-min-and-max-value-in-a-bar-chart/td-p/1537187
https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting
Regards,
Nikhil Chenna
Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!Thank you Nikhil. i wil try to learn from the reference link provided and if need help will definelty let you know thank you again
