Stack Exchange network consists of 183 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
@Lutzi This was done in cycles. The OP did not mention the use of any specific engine in the question(Although, I jst saw that he has put a eevee-render-engine tag). Also, this does give the effect the OP requires(Atleast in cycles). So I am keeping this answer. I will edit and add that this can be done only in Cycles.
