Forum Discussion
feasibility power bi
how to create table in power bi as much as similar to below
Hello powerbiexpert22,
If you want to recreate this table in Power BI, Deneb is the way to go. The native table visual just doesn't give you enough flexibility for this kind of layout.
Get started:
Grab Deneb from AppSource and install it
Pull in your fields — Product, Category, Actual, Target, Status
Inside the Vega-Lite JSON, you'll stack these layers:
Thin color bar on the left → rect mark
Progress bar → bar mark driven by DIVIDE([Actual],[Target])
The numbers and sub-text → text marks
On Track / Delayed badge → text mark with a color condition
Two DAX measures to create first:Pct = DIVIDE([Actual],[Target]) Label = FORMAT([Actual],"0") & "/" & FORMAT([Target],"0") & " (" & FORMAT([Pct],"0%") & ")"Once everything is set up in Deneb, the table will look exactly like what you're going for.
- Please try Power BI using Matrix + SVG in cells:
https://www.sqlbi.com/articles/creating-custom-visuals-in-power-bi-with-dax/
6 Replies
- danextian
Super User
These are achievable with DAX generated SVG images. I would save my pbi file as pbip and feed the tmdl files to Claude so it can have a look at your semantic model structure, upload this image to claude and ask it to generate SVG codes for Contribution, Cost and Status. You would of course need Claude more context as to what measures calculations to use. Alternatively, you can also use an html visual. Try this tutorial https://www.youtube.com/watch?v=KV84OuB5q_4
- krishnakanth240
Super User
This can be achieved using a Matrix visual combined with conditional formatting, data bars, and SVG based measures.
Using rows for Product and Category, applying data bars to Contribution and Cost measures, and using SVG icons or Unicode symbols for status indicators.
https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting
https://learn.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-conditional-formatting
https://www.cittabase.com/image-url-use-svg-images-in-power-bi-2/
- Olufemi7
Super User
Hello powerbiexpert22,
If you want to recreate this table in Power BI, Deneb is the way to go. The native table visual just doesn't give you enough flexibility for this kind of layout.
Get started:
Grab Deneb from AppSource and install it
Pull in your fields — Product, Category, Actual, Target, Status
Inside the Vega-Lite JSON, you'll stack these layers:
Thin color bar on the left → rect mark
Progress bar → bar mark driven by DIVIDE([Actual],[Target])
The numbers and sub-text → text marks
On Track / Delayed badge → text mark with a color condition
Two DAX measures to create first:Pct = DIVIDE([Actual],[Target]) Label = FORMAT([Actual],"0") & "/" & FORMAT([Target],"0") & " (" & FORMAT([Pct],"0%") & ")"Once everything is set up in Deneb, the table will look exactly like what you're going for.
- pcoley
Super User
Please try Power BI using Matrix + SVG in cells:
https://www.sqlbi.com/articles/creating-custom-visuals-in-power-bi-with-dax/ - v-menakakota
Community Support
Hi powerbiexpert22 ,
Thanks for reaching out to the Microsoft fabric community forum.
I would also take a moment to thank danextian , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.
I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you.Best Regards,
Community Support Team- v-menakakota
Community Support
Hi powerbiexpert22 ,
I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you.
Best Regards,
Community Support Team