Graph for ranges

[Muhammad_Wasif]

Hi,

i want to add a bar graph which is based on ranges. i am also attaching a sketch showing how i want the bar graph and procedures to work. my question is, is it possible in Power BI to draw such type of graph Range Graph

[NikhilChenna]

Hi @Muhammad_Wasif , You need only one graph the incentive graph or the colorful graph ?

Regards,

Nikhil Chenna

[Muhammad_Wasif]

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.

[NikhilChenna]

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!

[Muhammad_Wasif]

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