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))
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
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?
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)?
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
@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?
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.
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.
![[IBCS] New Column chart in Power BI - Feb 2024 Update](http://i.ytimg.com/vi/4Kn9jmgUlnY/mqdefault.jpg)
![[IBCS] New Column chart in Power BI - Feb 2024 Update](/img/tr.png)
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.
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 :)
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 😁
Great video Injae! Love a bit of SVG 🙌
Thanks Will, it's pretty much the best "workaround" we have :)
The next level !!👍
Fantastic video, thank you for sharing!
Thank you!!!! Keep the videos coming!!!
You bet!
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?
Amazing work
Thanks Injae
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)?
Is it possible to make two lines with two different colors for PY and AC?
Thank a lot for that tutorial it's a gold! Could you show also how to change chip icon for a custom one?
Thank you for sharing!!
Extremely useful 👌
awesome, thanks for sharing!
Thanks for watching!
Amazing ❤
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
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.
Great! Thanks you bro
Amazing
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!
How I can do the same in excell?
I think Leila has a video on this 😁
Noice!
thx
You are great ¡¡¡