Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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:
data:
https://drive.google.com/file/d/1l8NKF3K3iss5Mjwt05TqiiqRlxAz2AN_/view?usp=sharing
Solved! Go to Solution.
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.
User | Count |
---|---|
84 | |
76 | |
75 | |
43 | |
36 |
User | Count |
---|---|
109 | |
56 | |
52 | |
48 | |
43 |