NATIVE Power BI Table - Advanced Tutorial

Рет қаралды 17,983

4 ай бұрын

Make this with a native PBI Table!
=================================
Andrzej's Github🔥github.com/avatorl/IBCS-for-P...
Andrzej's IBCS video🔥 • Want to Upgrade Your P...
Davide's Github🔥github.com/PBI-David/SVG
Brian Julius' post: TOCSV🔥www.linkedin.com/posts/brianj...
Kerry Kolosko's SVG Templates🔥kerrykolosko.com/portfolio-ca...
Workout Wednesday Table🔥workout-wednesday.com/pbi-202...
Base64 converter🔥www.base64-image.de/
Icon8 (free license)🔥icons8.com/icon/set/flags/flu...
=================================
DATA:
Country , Region , 2022 , 2023
United States , North America , 8975632 , 9123459
China , Asia , 9421543 , 8587312
Japan , Asia , 7823874 , 7235981
Germany , Europe , 6548910 , 6826789
United Kingdom , Europe , 5412345 , 5689123
France , Europe , 4623981 , 4965874
Canada , North America , 3231567 , 3412789
Australia , Oceania , 2865432 , 2648921
India , Asia , 6912876 , 6310453
Brazil , South America , 3621567 , 3856789
South Korea , Asia , 2312765 , 2487654
Russia , Europe , 1987234 , 1754321
Italy , Europe , 4156789 , 4423567
Spain , Europe , 3365432 , 3132654
Mexico , North America , 2721987 , 2985432
South Africa , Africa , 1432345 , 1678432
Saudi Arabia , Asia , 1654321 , 1598765
Turkey , Asia , 2213876 , 2109876
Argentina , South America , 1821543 , 1754321
Netherlands , Europe , 3812765 , 3753987

Пікірлер: 45

@stevannsevellec1692 4 ай бұрын

Thanks very much for this Howto. Changing the PY&AC format to "$# ##0,K" removes the quotation marks

@PowerBIPark 4 ай бұрын

Nice! Thanks for that information

@testjo1 4 ай бұрын

Another quick note: when working with a live connection to SSAS, the TOCSV function is not available. Another method would be to use CONCATENATEX. So leaving the rest of the variables the same I managed to get similar visual results with replacing the TOCSV part with: CONCATENATEX(_Table,[Value],UNICHAR(10))

@JA-iv8np 4 ай бұрын

This is pure GOLD!! Love IT.

@patrickosorio7424 4 ай бұрын

Great video bro, keep doing this kind of videos based on IBCS ... love it

@alexking8222 4 ай бұрын

Fantastic video, thank you for sharing!

@rkortez 4 ай бұрын

Thank you!!!! Keep the videos coming!!!

@PowerBIPark 4 ай бұрын

You bet!

@zhangyue2740 3 ай бұрын

Thank you for sharing!!

@lukev730 4 ай бұрын

Amazing work Thanks Injae

@LearnMicrosoftFabric 4 ай бұрын

Great video Injae! Love a bit of SVG 🙌

@PowerBIPark 4 ай бұрын

Thanks Will, it's pretty much the best "workaround" we have :)

@alexrosen8762 4 ай бұрын

Extremely useful 👌

@Nalaka-Wanniarachchi 4 ай бұрын

The next level !!👍

@patrickharilantoraherinjat2994 4 ай бұрын

Great! Thanks you bro

@emilymalkin270 4 ай бұрын

Amazing ❤

@dadizalamite 4 ай бұрын

Amazing

@fsanfo 4 ай бұрын

awesome, thanks for sharing!

@PowerBIPark 4 ай бұрын

Thanks for watching!

@clementbogaert556 4 ай бұрын

bug in the matrix at 5:38, had to make sure my laptop didn't break :D thank you, once again, for the great content!

@PowerBIPark 4 ай бұрын

Ah I missed that! nice catch :)

@user-vx4qt1vu3q 29 күн бұрын

Thank a lot for that tutorial it's a gold! Could you show also how to change chip icon for a custom one?

@moxie1189 4 ай бұрын

HI Injae, Great video as usual. Try this to get rid of the quotes. PY & AC = VAR Line1 = "PY: " & FORMAT([PY], "#,###,###") VAR Line2 = "AC: " & FORMAT([AC], "#,###,###") RETURN Line1 & UNICHAR(10) & Line2

@PowerBIPark 4 ай бұрын

Thanks! Apparently setting the format to be currency also works 😁

@cathrerinezetadrones3169 4 ай бұрын

Noice!

@churtado1984 4 ай бұрын

You are great ¡¡¡

@arunv1909 4 ай бұрын

thx

@dganalysis 4 ай бұрын

Great work Injae

@PowerBIPark 4 ай бұрын

Thanks Gerard! Watch out for the next one coming soon :)

@dganalysis 4 ай бұрын

@PowerBIPark cool. I used the chip markers today, but slightly modified the content and icons. It's a good technique. I haven't done a whole lot of work with it yet, but do you know how to get rid of the "tooltip" when you hover over the chip marks?

@PowerBIPark 4 ай бұрын

@@dganalysis yeah man, I'll also ping you images on linkedin, but the simplest way to do it is to make a tooltip page.... 1x1px size

@kittyngaipuikwan7087 2 ай бұрын

Is it possible to make two lines with two different colors for PY and AC?

@Simone_R_C 4 ай бұрын

Thank you for this i will practice for sure thanks to your video!I was wondering if tables/charts created in SVG/Deneb can filter or interact with other visualisations in the dashboards or they looks similar to a “normal” image ? Imagine to have a dashboard with the table you have showed in the video and a bar chart, if you click/ select a row/field in the table in SVG, the bar chart got filtered or you cannot interact trough different charts with a SVG table? Hope the question is clear ahah! Thank you Sir

@PowerBIPark 4 ай бұрын

It's alright, so the bar chart as an SVG is part of just the row in the table, and it can work with crossfiltering no problem, or interacting with filters.

@Simone_R_C 4 ай бұрын

@@PowerBIPark Super! I will try it then, thanks a lot! It was helpful!

@DATA_AXE 4 ай бұрын

Great video. Thanks. I’ve replicated this for a project I’m working on. How do you change the number of decimal places for the AC,PY? I’ve looked in the measure and SVG file.

@PowerBIPark 4 ай бұрын

Thanks Paul! So it's pretty easy, and it's all in the format. Let's say you want two decimals then you can just put "#, ###, ###.00" As the format 😊

@DATA_AXE 4 ай бұрын

@@PowerBIPark SVG Style = //SVG code " " In this measure?

@PowerBIPark 4 ай бұрын

You know where I comment out _value? It's there.

@DavidPesante 4 ай бұрын

Just curious..have you tried this with thousand of records...just trying to see then performance impact as the data grows...

@PowerBIPark 4 ай бұрын

It's a good question, and I can tell you the performance is good, up to millions of rows in the fact table: www.linkedin.com/feed/update/urn:li:activity:7166378564932644864?updateEntityUrn=urn%3Ali%3Afs_feedUpdate%3A%28V2%2Curn%3Ali%3Aactivity%3A7166378564932644864%29