Insert intermediary rows on matrix table

Question

Hello! I have this model that displays my funnel volumetry of deals for each month on each step of the funnel. I would like to insert intermediary columns between each funnel_step displaying the conversion rates (also with 3 columns: result, target and % achieved). But I couldn't figure out a way to do that, since the columns funnel_step is a column on my table, and the conversion rate is not a existing column. How is there any way I could do that? Maybe creating a new auxiliary table? Thank you advance.

Here is attached my .pbix file: https://drive.google.com/file/d/1V9Ahde3DAfIFugiRAvpibl-XL3kFcwHp/view?usp=sharing

natarajan_m · Accepted Answer

Hi&nbsp;EugenioProlog&nbsp; ,&nbsp;I created individual measures to get the layout as close as possible to your requirement.Let me know if this works. I have turned off the width of the visual and used the text box as headers, and grouped it as a single visual .Solution:conversion funnel table.pbixThanks&nbsp;If you found this helpful, please consider giving it a kudo and marking it as the accepted solution — it goes a long way in helping others facing the same issue.For more Power BI tips and discussions, let’s connect on LinkedIn:https://www.linkedin.com/in/natarajan-manivasaganCheers!&nbsp;

Forum Discussion

Insert intermediary rows on matrix table

2 Replies

Related content

Sharing semantic models through intermediary

Identity Insert On Warehouse table

Issue in Inserting Formula in Table or Matrix View

insert custom shape

Matrix table