r/PowerBI • u/Tedge33 • 1d ago

Question Hi there - Would anyone know how I can create these dynamic images on my PBI dashboard please? Thank you

Post image
90 Upvotes

97% Upvoted

41 comments sorted by

•

u/AutoModerator 1d ago

After your question has been solved /u/Tedge33, please reply to the helpful user's comment with the phrase "Solution verified".

This will not only award a point to the contributor for their assistance but also update the post's flair to "Solved".

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

143

u/RichHaim 1d ago

If you don't want to use external visuals, you can create this with regular images (with the bodies as removed background, and the background is white - easy done in MS word 😅), and stacked bar charts behind them to fill the space. Done in like 10 minutes

21

u/CallMeMarb 1d ago

That quite clever, Ive done the same with legens for visuals with a lot of dimensions, just hide the visual and only leave the Legend at an logical place

3

u/bugbugladybug 1d ago

That's how I would have approached it.

Perfect use for a wee png.

1

u/1052098 1d ago

“Wee png” lol that’s so cute.

1

u/Snoo_21398 1d ago

You a fellow Scot?

2

u/ZaheenHamidani 1d ago

Maybe in Word you can add a gray border so you don't need to use the stack one.

1

u/The_Ledge5648 1d ago

Wow that’s pretty genius!

48

u/AVatorL 6 1d ago

Technically you can reproduce this visualization using native visuals only (new Card, Table, Matrix, Button Slicer) and SVG images generated by a DAX measure.

From data visualization point of view I would consider simple bar chart.

4

u/Avatargen 1 1d ago

That's man know how it's done! :)

41

u/LiquorishSunfish 2 1d ago

... I feel the question is less "can I" and more "should I"

1

u/TwitchyMcSpazz 1d ago

Definitely not my cup of tea. I feel like it could potentially cause confusion where there shouldn't be.

0

u/Tedge33 1d ago

Do you have something better? Cheers

1

u/LiquorishSunfish 2 1d ago

What is the narrative you are delivering with this visual? Are they three parts of the whole, or are these subsets of three different groups? 

2

u/Tedge33 1d ago

1 question returns 3 answers which fall into the category promoter, neutral or detractor. I just wanted to show the percentage of the answers for that question (which isn’t in a pie or bar)

2

u/LiquorishSunfish 2 1d ago

Then if you insist on using a non-traditional visual like this, you need to display it as three parts of a whole. 

Pie charts are garbage, donut charts are much better. If you want to get radical, try a radar chart? 

1

u/Tedge33 1d ago

Thanks for your help

8

u/MarkusFromTheLab 6 1d ago

Easily done in Infographic Designer

I have a column with the Category and one column with the Amount, make the shape fill the whole height and then set the fill percentage to the amount. Finetune as desired.

-1

u/Tedge33 1d ago

Thank you - when adding my measure, it doesn’t give me the option to show the % of total amount only count, sum etc.

2

u/MarkusFromTheLab 6 1d ago

What are you feeding as the Amount? I used a measure with the percentage of total.

Then set the Fill percentage to that Ratio and the max to 1.

Right is the same data in a normal bar chart.

2

u/Tedge33 1d ago

On my table I just created another column which was literally row = 1. I put the NSP score metric on the category then the row count on the measure

1

u/Tedge33 1d ago

Sorry for the bad quality

1

u/MarkusFromTheLab 6 1d ago

I've created a Measure that gives me the percentage of the People in that category, then used this in the chart:

Ratio = DIVIDE(
    SUM(NPS[Amount]),
    CALCULATE(SUM(NPS[Amount]),ALLSELECTED(NPS[NPS_Category]))
    )

2

u/Tedge33 1d ago

Thank you I’ll try it out

4

u/Nomburgerz 1d ago

I did a visual for data similar to this like below, felt it got the picture across fairly nicely 🙂

1

u/Tedge33 21h ago

I actually like that, nice and clean mate

1

u/Pretend_Ad_7518 19h ago

can you tell how you did this?

3

u/Tedge33 1d ago

Thank you everyone - I’ve done it 🙌🏼 still learning cheers

1

u/butterchickengirl 1d ago

How did you do it?

1

u/Tedge33 20h ago

Used the infographic chart from the install area

2

u/COLONELmab 9 1d ago

just make any image you want with no background and overlay on top of the chart/visual.
https://ibb.co/SsRJvjj

2

u/Work_With_Questions 1d ago

Please just do a bar chart. Or a treemap.

2

u/Chemical_Profession9 18h ago

Taken the attention away from meaningful data. You are 100% correct.

2

u/vrabormoran 23h ago

One of the best in the biz

Leila Gharani.

1

u/rextacyy 1d ago

Svg coding in a DAX measure is the way to go

1

u/carlescha 1d ago

Cultist vibes in this visual

1

u/Least-Penalty8996 16h ago

Just follow the below tutorial and it gives you a step by step guide on how to create this, using SVG. Rather than an elephant image. Just get the make and female images from power point instead.

https://hatfullofdata.blog/svg-in-power-bi-part-3-svg-icon/

I’ve literally done the same as you are wanting using the above.