Replicate this excel chart/heatmap with percentage bar in PowerBI

[S_M_]

Hi,

How can I replicate this Excel chart in Power BI. The gray bar is the overall percentage for a given vendor.

Any help is appreciated.

Thanks,

[amitchandak]

@S_M_ , You can get the bar,  using a measure like

divide([current measure], calculate([current measure], removefilter(Table[Vendor]) ) )

If the background is conditional formatting, you can not get 3 colors

Percent of Total and Percent of SubTotal https://www.youtube.com/watch?v=6jTildcV2ho
https://www.youtube.com/watch?v=cN8AO3_vmlY&t=24270s