NATIVE Power BI Table - Advanced Tutorial

[@stevannsevellec1692]

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

[@PowerBIPark]

Nice! Thanks for that information

[@testjo1]

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))

[@clementbogaert556]

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]

Ah I missed that! nice catch :)

[@patrickosorio7424]

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

[@user-ot6dy1df5y]

Thank you so much for sharing.

[@JA-iv8np]

This is pure GOLD!! Love IT.

[@moxie1189]

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]

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

[@alexking8222]

Fantastic video, thank you for sharing!

[@rkortez]

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

[@PowerBIPark]

You bet!

[@LearnMicrosoftFabric]

Great video Injae! Love a bit of SVG 🙌

[@PowerBIPark]

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

[@ginaramirez2313]

Thanks for the video! Really insightful.... question: Is there a way to create a table with categories row groups ( the same way that Access reports allows you to group by categories)?

[@Nalaka-Wanniarachchi]

The next level !!👍

[@zhangyue2740]

Thank you for sharing!!

[@Sandra-b4c1r]

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

[@kittyngaipuikwan7087]

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

[@ajibadeadeleke5203]

Awesome video. A quick question; How did you create the status column values looking like that? Did you do that in figma and import the image into the table?

[@trang367]

Great video, bro! I tried to change the size of the SVG donut by multiplying 2 times for width and weight but nothing changed. Am I missing something? Once again, I appreciated your tutorials.

[@lukev730]

Amazing work Thanks Injae

[@DATA_AXE]

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]

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]

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

[@PowerBIPark]

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

[@fsanfo]

awesome, thanks for sharing!

[@PowerBIPark]

Thanks for watching!

[@DavidPesante]

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

[@PowerBIPark]

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

[@alexrosen8762]

Extremely useful 👌

[@emilymalkin270]

Amazing ❤

[@patrickharilantoraherinjat2994]

Great! Thanks you bro

[@Simone_R_C]

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]

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]

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

[@moth_la]

Amazing

[@williamacevedo1364]

How I can do the same in excell?

[@PowerBIPark]

I think Leila has a video on this 😁

[@dganalysis]

Great work Injae

[@PowerBIPark]

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

[@dganalysis]

@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]

@@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

[@dadizalamite]

Amazing

[@cathrerinezetadrones3169]

Noice!

[@arunv1909]

thx

[@churtado1984]

You are great ¡¡¡