Forum Discussion
powerbiexpert22
Impactful Individual
Impactful Individualcard with segretion using bars
can it be possible to create below card in power bi ?. i tried using new card and create sperate chart but unable to combine both pbix: https://docs.google.com/spreadsheets/d/1VaOgc2zCR_lbG8CCtYvH4...
Please try this:
First of all, I create a SVG measure:
Measure = "data:image/svg+xml;utf8, <svg xmlns='http://www.w3.org/2000/svg' width='100' height='10'> <rect x='0' y='0' width='"&100*[Private Count]&"' height='10' fill='deepskyblue'/> <rect x='"&100*[Private Count]&"' y='0' width='"&100*[Public Count]&"' height='10' fill='blue'/> <rect x='"&100*[Private Count]+100*[Public Count]&"' y='0' width='"&100*[Business Count]&"' height='10' fill='red'/> <text x='"&100*[Private Count]&"' y='7' text-anchor='end' font-size='5'>"&100*ROUND([Private Count],2)&"%" &"</text> <text x='"&100*[Private Count]+100*[Public Count]&"' y='7' text-anchor='end' font-size='5'>"&100*ROUND([Public Count],2)&"%" &"</text> <text x='100' y='7' text-anchor='end' font-size='5'>"&100*ROUND([Business Count],2)&"%" &"</text> </svg>"Then add a new card:
Next, click formatting > visual > Images
Open the Image and select image url in image type:
The result is as follow:
Best Regards
Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Please try this:
First of all, I create a SVG measure:
Measure =
"data:image/svg+xml;utf8,
<svg xmlns='http://www.w3.org/2000/svg' width='100' height='10'>
<rect x='0' y='0' width='"&100*[Private Count]&"' height='10' fill='deepskyblue'/>
<rect x='"&100*[Private Count]&"' y='0' width='"&100*[Public Count]&"' height='10' fill='blue'/>
<rect x='"&100*[Private Count]+100*[Public Count]&"' y='0' width='"&100*[Business Count]&"' height='10' fill='red'/>
<text x='"&100*[Private Count]&"' y='7' text-anchor='end' font-size='5'>"&100*ROUND([Private Count],2)&"%" &"</text>
<text x='"&100*[Private Count]+100*[Public Count]&"' y='7' text-anchor='end' font-size='5'>"&100*ROUND([Public Count],2)&"%" &"</text>
<text x='100' y='7' text-anchor='end' font-size='5'>"&100*ROUND([Business Count],2)&"%" &"</text>
</svg>"Then add a new card:
Next, click formatting > visual > Images
Open the Image and select image url in image type:
The result is as follow:
Best Regards
Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.