Another great video, Bas! It's amazing how you treat a lot of concepts (some of them advanced ones) always with pratical and really useful examples hacking limited Power BI native options. You could make more videos about these amazing capabilities of calculation groups.
Love this Bas...One of the reason's I loved qlikview was that almost EVERY piece had "formatting" options and HIDE/SHOW type functionality so you could get as creative as you wanted with this kind of stuff. Nice to see PBI starting to get more and more options like this...even if it's sometimes a pain to do all the workarounds.
Awesome content - I love how you touched on a variety of concept points. For example, I have no experience with the Tabular Editor, so now know to investigate further.
LOVE the way you hack your way to achieve your end goals! Also LOVE that you are stocking up your hacking toolbox by exploring and learning all the options and their behaviors for potential future uses. Hats off, Bas!
Awesome video. I just started working with Tabular Editor and calculation groups but only used these groups in matrix tables. The options are actually endless. Thank you for the insights!
15:57 There is no such function as SELECTEDFORMATSTRING. The correct function is SELECTEDMEASUREFORMATSTRING. The overall video is really awesome. The reason I've found the issue is because I've tried to do all the steps to get this great visualization. Thanks Bas!
Love it! I think I will change on Monday some of my visuals using this tricks. Quick suggestion or ask, where I can learn the basics from the calculated groups? I can see that it can help me a lot in different scenarios. Thanks for your help!
Seems like a huge work around. If seen similar done in Tableau with much neater solutions. In an enterprise setting using w3rd party addins and supporting/documenting this type of workaround is a nightmare. Really would push you to request Power BI to add this as a feature in a future release. You skills aren’t in question:)
100% agree, should be way easier - in tableau its just drag drop a field on labels. haha I'm flattered by how much you think Microsoft would listen to me? 😆😂 (the request for measure driven data labels is there since 2019)
Dude this is fucking sick, I love it! Great content, I've watching more videos of you recently and great work dude! I always love to discover new cool stuff to improve visuals so this is awesome
I have been implementing all your ideas in my work lately, thank you so much! but i have a slight problem, as im comparing actual vs last 12 month finance cost, sometimes the % difference is divided by -123/-456 and it is giving one negative sign in the visual. Can you explain further what does the double quotation do in the formula where you applied """"&Format(Pct,"0%"). I tried different ways but still couldn't eliminate the extra negative sign.
Hi bas, have you found a way to introduce a line break in the formatting expression? I would love to place two values. Eg first line the absolute amount, second line the yoy difference, etc.
@@HowtoPowerBI yeah I tried unichar also incombination of 10 and 13 as well as putting a line break in a variable. nothing worked ... I guess it makes sense. We are already kind of "abusing" the format string. I can't think of a true format string that would ever include a new line. Hopefully, Microsoft will simply add measure driven data labels out of the box and then I'm sure we'll be able to add a line break as well.
Hii Can u please tell me how can i solve SQL views without using the views itself, with the help of data verse tables. (Backend got changed from sql to dataverse)
Hi Bas, great stuff as always! The only downside to this solution might be the tooltips being confusing due to the layering of measures. We could apply custom page tooltips I guess but I was wondering if you have any magic up your sleeves in that regard :) Thanks for content!
verifique dos veces la fórmula para la expresión de formato (tal vez haya un error en la condición lógica / declaración if) ... si no puede encontrar el error, devuelva algo simple primero como "prueba" y vea si cambia las etiquetas. Si es así, sabrá que es un error en la fórmula. Si no devuelve "prueba" en las etiquetas, entonces no aplicó el elemento de cálculo correctamente en el panel de filtro
@@HowtoPowerBI thanks for responding, doesn't look like I can add an image, it basically looks like a Gantt chart with a target line as the water level, There are 6 levels and we would only see the benefit when we enter the last stage, after time more things will start to emerge above the waterline. Sorry it's hard to explain, no problem if you haven't seen or heard of one, first time I saw one but not willing to pay a contractor 😁
Another great video, Bas! It's amazing how you treat a lot of concepts (some of them advanced ones) always with pratical and really useful examples hacking limited Power BI native options. You could make more videos about these amazing capabilities of calculation groups.
so nice to hear, thx a lot! got a few already, but pretty sure I'll need them for some future hacks haha 😄
Love this Bas...One of the reason's I loved qlikview was that almost EVERY piece had "formatting" options and HIDE/SHOW type functionality so you could get as creative as you wanted with this kind of stuff. Nice to see PBI starting to get more and more options like this...even if it's sometimes a pain to do all the workarounds.
Exquisite. Clean, Impactful. Genius! Thank you so much for your continued work and inspiration!
so nice to hear! thanks a lot 😊😀
Awesome content - I love how you touched on a variety of concept points. For example, I have no experience with the Tabular Editor, so now know to investigate further.
Thank you Anthony! 😊 oh so much exciting stuff waiting for you then!
LOVE the way you hack your way to achieve your end goals! Also LOVE that you are stocking up your hacking toolbox by exploring and learning all the options and their behaviors for potential future uses. Hats off, Bas!
😊thanks Hachi! true - that hacking toolbox becomes bigger and bigger haha (though I wish sometimes less hacks would be necessary haha)
So true. Hopefully, Power BI Team at Microsoft is taking notes! 😉
Awesome video. I just started working with Tabular Editor and calculation groups but only used these groups in matrix tables. The options are actually endless. Thank you for the insights!
Thanks Craig! Oh so many exciting things you can do with tabular editor - definitely worth exploring more!😊
15:57 There is no such function as SELECTEDFORMATSTRING. The correct function is SELECTEDMEASUREFORMATSTRING. The overall video is really awesome. The reason I've found the issue is because I've tried to do all the steps to get this great visualization. Thanks Bas!
thanks Alex, you are right (typed it in wrongly on my first try). 16:10 it shows correctly though
Started PBI only few days ago. Able to do so much because of you, thanks from France ! :D
You are welcome! Very happy to hear this!
Gracias por compartir conocimientos, saludos desde Perú.
Gracias por visualizar mi video Ivan 😊
Amazing tricks & methodology ... Thanks a million for the sharing ... I'll make sure to watch all your videos 💪🏻😊👍🏻👍🏻👍🏻
Very creative, Bas. Great to see this being worked through.
Very creative!
Thanks Chris:):)
Love it! I think I will change on Monday some of my visuals using this tricks. Quick suggestion or ask, where I can learn the basics from the calculated groups? I can see that it can help me a lot in different scenarios. Thanks for your help!
Genius! Thank you for sharing Bas.
:) happy you liked it!
Thanks baas , this video helped me in understanding calculation group better .
Thanks for watching Naveeth! Calculation groups are great definitely worth exploring further
Really amazing!!! Thanks for sharing this.
great to hear thx a lot for watchn 😊
Thank you!
thx for watching Vinicius!! 😊
Seems like a huge work around. If seen similar done in Tableau with much neater solutions. In an enterprise setting using w3rd party addins and supporting/documenting this type of workaround is a nightmare. Really would push you to request Power BI to add this as a feature in a future release. You skills aren’t in question:)
100% agree, should be way easier - in tableau its just drag drop a field on labels. haha I'm flattered by how much you think Microsoft would listen to me? 😆😂 (the request for measure driven data labels is there since 2019)
@@HowtoPowerBI exactly...so many requests just go unanswered....
Awesome
You are great Bas, I really like your videos and how you explain
thank you so much Mohamed!
You never disappoint
Awesome. This is really helpful Bas. Thank you very much
Glad it was helpful! thanks for watching again😊
I love it! Great video, Bas!
Dude this is fucking sick, I love it! Great content, I've watching more videos of you recently and great work dude! I always love to discover new cool stuff to improve visuals so this is awesome
Thank a lot Christofher!
the video is as always very interesting, thank you very much
thanks for watching!!
Simply superb ❤
Thx Santhosh!
I have been implementing all your ideas in my work lately, thank you so much! but i have a slight problem, as im comparing actual vs last 12 month finance cost, sometimes the % difference is divided by -123/-456 and it is giving one negative sign in the visual. Can you explain further what does the double quotation do in the formula where you applied """"&Format(Pct,"0%"). I tried different ways but still couldn't eliminate the extra negative sign.
Hi bas, have you found a way to introduce a line break in the formatting expression? I would love to place two values. Eg first line the absolute amount, second line the yoy difference, etc.
I tried different things like play around with unichart(10) and empty characters, but didn't manage so far. Let me know if you find a solution
@@HowtoPowerBI yeah I tried unichar also incombination of 10 and 13 as well as putting a line break in a variable. nothing worked ... I guess it makes sense. We are already kind of "abusing" the format string. I can't think of a true format string that would ever include a new line. Hopefully, Microsoft will simply add measure driven data labels out of the box and then I'm sure we'll be able to add a line break as well.
Great! Bas please, do one for translation/localization.
Thank you Jose! Will put it on my to do list 😉
Hi, what is the name of editor which you are using to create formating table?
awsome!! how do you know that!??? i really appreciated!!!!!!!!
thanks for watching! haha I look at Power BI too much 😂
Hii
Can u please tell me how can i solve SQL views without using the views itself, with the help of data verse tables. (Backend got changed from sql to dataverse)
here is a video that I think will help you ua-cam.com/video/Px4-QZt6OoY/v-deo.html
Very nice
Thank you Mustafa 😊
Hi Bas, great stuff as always! The only downside to this solution might be the tooltips being confusing due to the layering of measures. We could apply custom page tooltips I guess but I was wondering if you have any magic up your sleeves in that regard :) Thanks for content!
Thank you Adam! 😊 yea, I was not paying attention to the tooltip here. I think custom tooltip is the way to go (or turning the tooltip off)
Replique lo hecho pero al momento de activar el filtro de la etiqueta de datos en el visual no me muestra el porcentaje. A que se debe?
verifique dos veces la fórmula para la expresión de formato (tal vez haya un error en la condición lógica / declaración if) ... si no puede encontrar el error, devuelva algo simple primero como "prueba" y vea si cambia las etiquetas. Si es así, sabrá que es un error en la fórmula. Si no devuelve "prueba" en las etiquetas, entonces no aplicó el elemento de cálculo correctamente en el panel de filtro
Valeu!
thank you so much for supporting the channel, I appreciate it a lot 😊
Чи можливі титри на іншій мові?
Have you ever built an iceberg chart in power bi? Is it even possible?
Do have a picture (linkto) of an iceberg chart?
@@HowtoPowerBI thanks for responding, doesn't look like I can add an image, it basically looks like a Gantt chart with a target line as the water level, There are 6 levels and we would only see the benefit when we enter the last stage, after time more things will start to emerge above the waterline. Sorry it's hard to explain, no problem if you haven't seen or heard of one, first time I saw one but not willing to pay a contractor 😁