Dynamic Constant Line Data Labels!
6:37
Community Feedback & Topic Ideas
1:24
Пікірлер
@mogarrett3045
@mogarrett3045 5 сағат бұрын
excellent
@AgulloBernat
@AgulloBernat Күн бұрын
This is indeed a nice use case for visual Calcs that I may use one day! Question: if some decrease makes it go below zero things get messy right?
@HavensConsulting
@HavensConsulting Күн бұрын
It one section is entirely 0, then I believe then you'd just have an "empty" section there? The negative or positive in the next section would just start from the same spot. You could maybe do an IF 0 then 1 or something, to give it a small line, and do a custom tooltip. To help "connect" the sections
@wygoda123
@wygoda123 Күн бұрын
People, add the measure 'Multiselect Drill Through ..." to the target drill-through page. Then, you will see a drill-through functionality on right-clicing the single card.
@HavensConsulting
@HavensConsulting Күн бұрын
Exactly!
@mrbartuss1
@mrbartuss1 2 күн бұрын
Nice! Have you ever created a stacked version of a waterfall chart?
@HavensConsulting
@HavensConsulting 2 күн бұрын
I've thought about it! But with this stacked chart + custom measures. You'd need to create a measure for each category then sadly. So for 2-4 it's doable, but much harder with a LOT of them. For advanced waterfall scenarios I really like the Inforiver Analytics+ Swiss army knife visualization. It has a handful of advanced waterfall charts that don't require any custom DAX. It's quite nice for those advanced scenarios! inforiver.com/analytics-plus/
@In_a_state
@In_a_state 2 күн бұрын
Good effort and execution, but it took me a bit to read an understand why do the values start and end from those points on the X axis. Ideally, instead of fully flipping the waterfall I think it would be easier to read if each bar would go from the PY value to CY value, indicate the start and end values at the edges and the delta in the middle. But this wouldn't be possible natively...
@HavensConsulting
@HavensConsulting 2 күн бұрын
Yeah this was following more of the traditional waterfall with a start value, variance journey, and end value. For advanced waterfall scenarios I really like the Inforiver Analytics+ Swiss army knife visualization. It has a handful of advanced waterfall charts that don't require any custom DAX. It's quite nice for those advanced scenarios! inforiver.com/analytics-plus/
@jakubosiecki1796
@jakubosiecki1796 2 күн бұрын
I was literally trying to figure it out for almost 1,5 hour, checking every possible option and combination and did not have a clue what is going on! T HA N K Y O U ! ! !
@sonalijha3003
@sonalijha3003 7 күн бұрын
Hi, great video, Gustaw Dudek! It would be awesome if you could share a sample PBIX file so we can practice too.
@sanjuladissanayake5295
@sanjuladissanayake5295 7 күн бұрын
This doesn't work. cannot do two actions using buttons
@havenscr
@havenscr 7 күн бұрын
Not sure I’m following? As this video is showing a working solution by the end of the video
@Milhouse77BS
@Milhouse77BS 8 күн бұрын
For small teams, just having Git version control good enough for me.
@mohsenalizadehfard
@mohsenalizadehfard 9 күн бұрын
What about for the end users? we want the end users to see it in Power BI Service also? any update?
@havenscr
@havenscr 9 күн бұрын
Since tabular editor is adding this info into a metadata field that’s unused by Power BI desktop. This wouldn’t be coming to Power BI natively anytime soon unfortunately. They were just clever on enhancing the TE3 experience! I would recommend submitting or voting for this on fabric.ideas though! Help convince Microsoft we need this natively 🙂
@GiacaloneSalvatore
@GiacaloneSalvatore 11 күн бұрын
Great stuff. Why have I never stumbled into your channel?!
@themolestones
@themolestones 16 күн бұрын
thanks
@earngsnsn
@earngsnsn 16 күн бұрын
Thank you so much
@elaf70
@elaf70 17 күн бұрын
Thanks to both of you Reid & Bas : This is a very instructive & useful tip from its original idea up to its improvement. Definitely one, I will reuse in next coming reports to create / update.
@workstuff5253
@workstuff5253 20 күн бұрын
What it your tattoo of?
@MucahitKatirci
@MucahitKatirci 21 күн бұрын
@barttrudeau9237
@barttrudeau9237 21 күн бұрын
Great video, consider trying some of the custom GPTs within ChatGTP, like DAX GPT. To me they seem to write better DAX
@havenscr
@havenscr 20 күн бұрын
When it comes to the actual DAX parts for sure. Since this was general SVG code changes most of the time I found 4o still worked quite well
@barttrudeau9237
@barttrudeau9237 20 күн бұрын
@havenscr that's interesting! Thanks
@johnswet3569
@johnswet3569 22 күн бұрын
Omg
@antique-bs8bb
@antique-bs8bb 23 күн бұрын
This is pretty much going to put instructors out of a job ;) But definitely learning is much much easier now. I thought you would do this with one generic svg which gives the image for each cell put into a table filtered by your scale adjustment. Without ChatGPT (or equiv) to do it your way as a single SVG would be a complete nightmare. Of course when so much is done by Chat GPT your way is probably simpler.
@havenscr
@havenscr 21 күн бұрын
It really simplifies things!
@originals3788
@originals3788 23 күн бұрын
Hi, all, I am stacked with the problem when Revenue has the same values for a few Product types. Pareto measure shows the same value for each of them. But I expect cumulative. Assume we need Rank, but wasn't succeeded. Can everyone help?
@aleksvpYT
@aleksvpYT 23 күн бұрын
Love it! Tks
@rayscholtens3176
@rayscholtens3176 23 күн бұрын
Super helpful video, even 2 years later! Do you happen to have a video explaining the measures you used to create the Value Fields parameter?
@HavensConsulting
@HavensConsulting 23 күн бұрын
Thank you! You can actually download this PBIX file from our blog page, and dissect the measures from there as well. Do you have access? You just need to be a blog subscriber. Links to the Files page in the video description
@annabazel8625
@annabazel8625 26 күн бұрын
Thanks a lot!
@hassanbolaji1886
@hassanbolaji1886 27 күн бұрын
Thanks so much.
@HavensConsulting
@HavensConsulting 26 күн бұрын
You're welcome!
@vanlessing
@vanlessing 27 күн бұрын
the total labels tweak is great
@HavensConsulting
@HavensConsulting 27 күн бұрын
It shapes it so perfectly right??
@pomodoriemozzarella
@pomodoriemozzarella 29 күн бұрын
Thanks so much @leslie-welch for bringing up the single-record bridge table, this looks like an absolute lifesaver for models with multiple m:m relationships! Any chance you could say a few more words about this approach: is the dim table here somewhat similar to a straightforward unpivot (i.e. "ListID1, PathID1, PathnameABC", "ListID1, PathID2, PathnameDEF", "ListID2, PathID1, PathnameABC", "ListID2, PathID3, PathnameXYZ", etc etc), meaning that there's a certain amount of row-level replication for PathID/Pathname; are those never featured in a unique-value DIM of their own?
@mabenba
@mabenba 29 күн бұрын
Very beautiful and elegant solution. Thanks for sharing!
@HavensConsulting
@HavensConsulting 28 күн бұрын
Thank you! Cheers!
@lukasj7689
@lukasj7689 Ай бұрын
to me this tool seems like a more advanced version of BPA. what i would do is first use BPA to scan my model, identify and fix the highlighted issues and then would use this dax optimizer to scan the model again for further issues.
@havenscr
@havenscr Ай бұрын
Great point, @lukasj7689! You’re spot on. BPA in Tabular Editor is a great starting place for model hygiene, catching issues like unused columns and naming inconsistencies. However, it doesn’t analyze the performance of DAX measures. That’s where DAX Optimizer shines, diving deep into query performance and identifying bottlenecks in your DAX code. By using both tools together, you get a solid workflow: 1. Use BPA first for a clean, well-structured model. 2. Then use DAX Optimizer to review and fine-tune your DAX measures. This approach ensures your model is both well-built and highly performant.
@hyperadapted
@hyperadapted Ай бұрын
Great video, very interesting to see whats possible. Inspiring 1:13:32 - I cant quite make out whose name he mentions: Nick de brows?
@gustawdudek5775
@gustawdudek5775 Ай бұрын
Nick Desbarats : ) Cheers!
@hyperadapted
@hyperadapted Ай бұрын
@@gustawdudek5775 ah yes, classic! Thanks Gustaw!
@gustawdudek5775
@gustawdudek5775 Ай бұрын
@@hyperadapted no problem!
@jamesrosicky2912
@jamesrosicky2912 Ай бұрын
Cool stuff, the 'disconnected tables' are something I wasn't aware of. thanks!
@zxccxz164
@zxccxz164 Ай бұрын
the current version of Dax Studio STILL doesn't work for define dependent measure.
@pk5134
@pk5134 Ай бұрын
Thanks for this! Is the powerpoint available for download ?
@martinbubenheimer6289
@martinbubenheimer6289 Ай бұрын
Great appoach! What are your thoughts on using preview features in production reports, like field parameters?
@hyperadapted
@hyperadapted Ай бұрын
As a Business Analyst in a fintech I build slightly complex dashboards and field parameters are really, and I can not stress this enough, really useful. The beauty is that it all works together very well. For example I have a tooltip chart that responds according to field parameters. Depending on which one I select, the chart displays different data. Then on the main page I have field parameters that switch granularities Y/Q/M/W/D of the charts, the buttons that switch the contents of the charts as well as additional buttons such as YTD/MTD. So if I select granularity Quarterly, Metric say Revenue by division and YTD then all of it (even the tooltip chart) are responding to the field parameters and slicing according to context. So much fun
@martinbubenheimer6289
@martinbubenheimer6289 Ай бұрын
@hyperadapted I can feel the fun ❤️
@KaterinaSarkisian
@KaterinaSarkisian Ай бұрын
Veri Informative information. Thanks Gustav for all excellent explanations . We would like to see you again in Havens 😊
@shahlaliaquat3194
@shahlaliaquat3194 Ай бұрын
Very Informative .
@pawewrona9749
@pawewrona9749 Ай бұрын
Great episode. One of the most packed with content I've seen. Great presentation by Gustaw.
@HavensConsulting
@HavensConsulting Ай бұрын
Glad you enjoyed it!
@wojciechjaniszewski9086
@wojciechjaniszewski9086 Ай бұрын
very impresive, well done Vijay and the team!
@APG67-q8l
@APG67-q8l Ай бұрын
Chandeep es fantástico, muy pedagógico explicando. Sus tutoriales son siempre inteligentes y originales.
@SM23Studio
@SM23Studio Ай бұрын
A comment on SelectedValue scenario. If you create a calculated column in a Field Parameter table - just to have a "copy" from the original name column - you can use the new column with SelectedValue. e.g. ParamTreatas_Display = 'Param Treatas'[Param Treatas] in this case I think it's a much easier method.
@muhammadsadiq2330
@muhammadsadiq2330 Ай бұрын
good topic chose for video
@re-upapp215
@re-upapp215 Ай бұрын
Life saver! Thanks!
@HavensConsulting
@HavensConsulting Ай бұрын
Glad it helped!
@NaveenKumar-lr6xj
@NaveenKumar-lr6xj Ай бұрын
Hi, how to connect azure log analytics from power bi desktop. Can you please explain that part?
@SurajBhattarai
@SurajBhattarai Ай бұрын
Thanks for sharing. How can I deactivate this feature? I've finished using it for development and would like to turn it off.
@HavensConsulting
@HavensConsulting Ай бұрын
Not sure I understand? This script is a one time run, so nothing to "turn off". Could you provide more context?
@SurajBhattarai
@SurajBhattarai Ай бұрын
@@HavensConsulting I have used this but I want to turn off the feature, is there a way, where I can remove the feature once I don't want any more.
@HavensConsulting
@HavensConsulting Ай бұрын
@@SurajBhattarai unfortunately I'm still not following. This script doesn't get turned on or off, it runs only a single time on any measures in the model. There isn't an undo option, where it remembers what the previous formatting is. So if you wanted to "undo" this, you'd need to go back to a previous version of the file.
@QuLaZz
@QuLaZz Ай бұрын
Very hard to follow😢
@HavensConsulting
@HavensConsulting Ай бұрын
Developer Mode is still sadly an intermediate/advanced topic. But we are trying to share important information to make it easier! Is there a particular topic you'd like more clarity on, under this topic?
@QuLaZz
@QuLaZz Ай бұрын
YTD in PQ is very easy, just sum the sales in last year, and join it to the customer table?
@HavensConsulting
@HavensConsulting Ай бұрын
Anything that is aggregating, or doing a running total I'd defer to DAX, since PQ is meant more for transformations/shaping of the data. Where DAX is primarily meant for aggregations. :)
@JBartlett_DMU
@JBartlett_DMU Ай бұрын
Leslie mentioned generating a bridge table column from a CRC32 (presumably using the CHECKSUM() function). Is there a specific reason to use that function instead of HASHBYTES()?
@leslie-welch
@leslie-welch Ай бұрын
@JBartlett_DMU Not that I am aware of, but I will ask the engineering team! I'll circle back and let you know what they say. The actual SQL function we are using in Databricks is CRC32() and it is wrapped around some array functions to get a distinct list and sort that distinct list. Things brings us down to the smallest number of records needed to meet the ListID need for our many to many relationships.
@JBartlett_DMU
@JBartlett_DMU Ай бұрын
@@leslie-welch Ahhh, so it's a Databricks SQL thing! I think I was assuming you were talking about T-SQL.
@leslie-welch
@leslie-welch Ай бұрын
@@JBartlett_DMU gotcha. My understanding is that Databricks is primarily based on Spark SQL with some additional functions specific to Delta tables. I haven't worked with T-SQL to my knowledge so I don't know exactly how it differs.
@pramodh311
@pramodh311 Ай бұрын
Hi, I have a scenario where I need to validate data between bronze table in one workspace and gold table in another work space. Can you please let me know weather cross workspace data validation is possible using DBT in fabric?
@PavanCh-q2u
@PavanCh-q2u Ай бұрын
Great...it's working as expected if we have 2 level hierarchy. Thank you. I have a scenario where I have more than 4-5 levels in the matrix table hierarchy... So at 1st level - it should pick only 1st level value 2nd level = it should pick 1st and 2nd level value 3rd level = it should pick 1st, 2nd and 3rd level value 4th level = it should pick 1st, 2nd, 3rd and 4th level value and add it to the hyperlink to drill through... In this case, will the hasonevalue function will work?.....I tried, but facing challenge...could you please help/provide some inputs here... Thank you.
@coolblue5929
@coolblue5929 Ай бұрын
What about multiple fact scenarios like sales orders and invoices. Parts of a sales order can be dispatched and invoices separately. Even sales order lines can be split with second dispatch for back-ordered quantity. There is a need to link sales order lines to invoice lines.
@leslie-welch
@leslie-welch Ай бұрын
What is the relationship between the two? Is it always one or more invoices per sales order, or are there also sometimes multiple sales orders associated with one invoice?
@mrbartuss1
@mrbartuss1 Ай бұрын
What about shared dimensions?
@coolblue5929
@coolblue5929 Ай бұрын
@@leslie-welch in my case it’s always one sales order per invoice and sometimes multiple invoices for a sales order.
@coolblue5929
@coolblue5929 Ай бұрын
@@mrbartuss1 the shared dimensions filter via the sales orders.
@leslie-welch
@leslie-welch Ай бұрын
@@coolblue5929 In this scenario I would look at incorporating the sales order fact into the invoice fact. It will of course create some replication at the row level of sales data, but if you can end up with a fact that is mainly dates and integers, and push as much of the text into dimensions, your DAX will be simpler and overall the report should be more performant.
@joser7909
@joser7909 Ай бұрын
I'm just getting into the world of Power BI and the course I'm taking has the old-fashioned slicer style... and I was racking my brains looking for this option... Thank you so much!!
@HavensConsulting
@HavensConsulting Ай бұрын
Fantastic!