Forum Discussion
Impactful Individualfeasibility power bi
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/
Super UserHello 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.