NATIVE Power BI Table - Advanced Tutorial
HTML-код
- Опубликовано: 19 фев 2024
- 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 - Наука
Thanks very much for this Howto. Changing the PY&AC format to "$# ##0,K" removes the quotation marks
Nice! Thanks for that information
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))
Great video bro, keep doing this kind of videos based on IBCS ... love it
This is pure GOLD!! Love IT.
Great video Injae! Love a bit of SVG 🙌
Thanks Will, it's pretty much the best "workaround" we have :)
Fantastic video, thank you for sharing!
Amazing work
Thanks Injae
Thank you!!!! Keep the videos coming!!!
You bet!
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!
Ah I missed that! nice catch :)
Thank you for sharing!!
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
Thanks! Apparently setting the format to be currency also works 😁
awesome, thanks for sharing!
Thanks for watching!
Great! Thanks you bro
Extremely useful 👌
Amazing
The next level !!👍
Amazing ❤
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
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.
@@PowerBIPark Super! I will try it then, thanks a lot! It was helpful!
Is it possible to make two lines with two different colors for PY and AC?
Great work Injae
Thanks Gerard! Watch out for the next one coming soon :)
@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?
@@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
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.
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 😊
@@PowerBIPark SVG Style =
//SVG code
"
"
In this measure?
You know where I comment out _value? It's there.
thx
You are great ¡¡¡
Just curious..have you tried this with thousand of records...just trying to see then performance impact as the data grows...
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
Noice!
How I can do the same in excell?
I think Leila has a video on this 😁
Amazing