What Every Power BI Visual Needs

[@HowtoPowerBI]

My report development process for experienced developers 🚀🔥✌️ datatraining.io/powerbidesigntransformation

[@personalsigh]

Incredibly creative to a solution that Microsoft shouldn't need you to have done. Very well done

[@GuyOrlov]

Wow the best artist of Microsoft Power BI, I don't know how you managed to find this solution and it must take you ages. THE POWER BI MASTER!

[@alex...g]

This might be your best work yet to be honest...this is SO clean. So useful. Thank you for posting!

[@Acheiropoietos]

For dedicated visual designers, this is perfect ❤ No complaints about the title, some people are so petty!

[@jasonstrong6608]

Bas, you have taught me so much since I've started watching your videos. I just want to thank you! Also, have you searched the 'Get more visuals' section? I found a version of this long ago called, 'Line and Stacked Column Chart with Table'. I may not be as visually pleasing as your work-around, but if someone is just looking for a quick and easy visual, this may work. Thanks Again for all you've done for Power BI!

[@TonyFregoli]

I implemented a similar solution before you posted this video, with the additional complexity that there are breaks in the data - and I wanted Power BI to interpolate and "join the dots" both in the "native" frequency and in the other levels of the hierarchy. As you know Power BI doesn't interpolate (in "categorical" mode, not "continuous", as I had to display custom time labels on the x-axis). There are different ways to do this, I opted to show the previous value (for that level of aggregation) for when there is a gap, but potentially you can actually figure out the equation of the straight line between the start and end known values (beware, not the actual data, but its calculated aggregated start/end values at the different levels of the hierarchy) and make Power BI to draw a nice upwards/downwards line.

[@dominiksch4928]

Nice workaround Bas. What every power bi visual needs is the correct color transformation from desktop to pbi service. Dashboard Design in Service feels like waterboarding ..

[@HowtoPowerBI]

Yeah also a good point ✌️🫣

[@diepic]

🔝 as usually!

[@minimax6112]

Soo cool. You are very creative.

[@HachiAdachi]

Brilliant, Bas! 👍 This should hold them off a few seconds longer before asking how they can download the data to Excel. 😅

[@moisesgonga1302]

kkkkkkkkk Please... how is it possible... kkkk???

[@piotrkuc8936]

That's quite impressive. Thank you for sharing and making it easy to follow

[@markNXCH]

Nice Tutorial, thank you very much!👌 Unfortunetly nothing happens when I use the put the Labels on the Y-axis. - Any Suggestions? Thank you guys!!

[@BobSmith-ti2in]

I’ve been thinking of doing something similar for weeks! Awesome timing for this video

[@denxx6126]

Crazy stuff... thx for sharing!!

[@HowtoPowerBI]

💻🤓

[@MrKhulaid]

That is really cool. I think I'm going to attempt this for my meeting next Friday. Keep up the amazing work

[@dcbelbiteam]

This is so creative and useful! Thank you so much!

[@just_pbi]

Perfect! Love this visual! You state that this is not yet available by default, however, do you think it will be possible to create this using a charticulator visual?

[@mercedesiacuzzi7767]

Wow! this is great! I will adopt it in my tables / charts. Thanks a lot!

[@juaniglesias6327]

As usual Bas, mind blowing and so interesting. Thanks for always smiling and putting such a good energy on all your videos 😊

[@erivaldolopes632]

That's fantastic. It is like wavering the wand 🤩

[@marcelobregunci]

This is really great! Amazing content

[@PeterKontogeorgis]

That’s nuts Bas. You’re definitely some kind of wizard.

[@Lho89]

Man, you really think out of the box to create visuals. Thanks to share

[@louism.4980]

Great work, Bas! It's a beautiful chart, but my goodness what a headache it is to build.

[@HowtoPowerBI]

🤣 love the comment

[@davepoppenhouse4459]

Absolutely brilliant!!

[@patrickharilantoraherinjat2994]

great work! love it

[@Dinamismo]

Impressive as always!

[@MrMcPeter]

Thank you for another great video! I hate that it needs so much tweaking and creation of multiple measures, but I love the creativity you put into making user-friendly and intuitive solutions that looks and works so well. I hope the Power BI developers watch your videos. 🙂 Keep up the good work!

[@HowtoPowerBI]

Thanks 😊 I agree, many times obviously needed functionalities are a pain to make possible dummy x dummy

[@victoramachree1302]

Top notch creativity.

Every time I see there is a new video notification from you I already know it will be an excellent content that I must watch... thank you so much!!

[@yahyalouizi2695]

Very clever, thanks for sharing.

[@HowtoPowerBI]

😎✌️

[@arbazahmad7177]

Amazing 👏... thanks for sharing 🎉

[@bakalogatos7]

Thats a great work around that most pbi developers were looking for. Are we able to create colums 2024 and 2023 rather than lines? And below to create custom measures?

[@KhangTran3011]

awsome !! thank you for your sharing 👍

[@HowtoPowerBI]

Thanks for watching ✌️🔥

[@ruslangusiev7677]

That’s superb Bas! Well done sensei!

[@HowtoPowerBI]

Thanks Ruslan!!!

[@patrickgaul6223]

Insane creativity

[@VictorYamaykin]

Total gamechanger 🤯 you could do something like this for same month / same day last year?

[@perfectionist6624]

Drill up and drill down I wanted the most ❤ Thanks Bas you are amazing 🎉

[@HowtoPowerBI]

❤️🔥

[@davedavedavedavedavedavedave]

Hey bro. How do you get the side panes yo stack on top of each other instead of side by side?

[@AlXmkL]

Amazing!

[@ivanlarutaespinal6639]

amazing, that looks so beautiful ❤❤

[@spen2431]

🤯 Mind Blown 🤯 - Thanks for sharing 👍👍

[@HowtoPowerBI]

Thanks for watching! 🚀😎

[@mohamedshiple1624]

You are very intelligent, I hope I be just 50% of you ❤

[@CBrown]

Microsoft really needs to just implement a solution for this. What you have here that is far more complex than it should be to achieve. I could sit here and look at PBI for days and never have thought of this. Well done. Microsoft needs to pay attention to things like this.

[@jaymehta3320]

This is mind-blowing. A lot of work, so would use it only if I know the client is really really going to use this chart for their business purposes but still a lot of tricks inside this one video. Thanks for sharing.

[@HowtoPowerBI]

Thanks for watching and for the encouragement:)

[@Viclex1]

I wish you could put on a 1hr training session for my department.

[@WhiteNinjaArt]

this is so good :) thanks for also showing the measures :)

[@HowtoPowerBI]

Sure! Glad you like ot

[@mohammedishaq9217]

Thanks a zillions - this is so very huge for my level, but would definitely try it on my work for sure in coming days. ❤❤

[@HowtoPowerBI]

Thanks for watching hope you can use it

[@myrandomandboringvideos]

Impressive trick.

[@DiegoRodriguez-tk4xy]

Muy buena aportación. Gracias

[@HowtoPowerBI]

✌️thx for watching

[@SuperMummyStein]

wow... just WOW.... you honestly make something so complicated look so easy... and although we all agree it should just be there "out of the box"... you are truly an inspiration in creating "outside of the box" workarounds !! #LEGEND ( so happy and positive about it too !! )

[@estebanfabiani9705]

Bas, your idea is not bad, but from my point of view, it takes a lot of time, plus: you need a lot of DAX, if you change the KPIs, you need to redo the measures, you use the IF function, not good for performance...I use a very simple solution: most of the graphic visuals bring the alternative of the "Show as a Table"...and you have all what you need there. Not so formatted as you have it but simple, quick and with really 0 effort and standard. You change the measures, and immediately you have the full data working. If you want it with a nice format, you create a Tooltip with all the features you like....as I said at the very beginning VERY good idea, but depends on the Customer, what they want, what will they pay for the solution...

[@nadasdij]

OMG - never would have guessed how you will do it in a million years - kickass out of the box thinking! ******** amazing!!!

[@thuytamdang3390]

Thank you very much. Love you ❤

[@HowtoPowerBI]

🤩✌️

[@josefedericopresno6668]

Absolute genius!

[@HowtoPowerBI]

✌️😎🤩

[@geineralbertomejiagarzon4034]

🤯🤯🤯 how do you find out these solutions, it's really amazing. Well, the visual is not so great when displays the data by yeat, however it's not something too relevant. Excellent job.

[@Fannie2uN2010]

you are greAt

[@mohammedishaq9217]

Next Video Suggestion: I work in huge data, for my 1 year of data, the pbix is already over 500MB, I want to continue with same file to have future months data as well. All my data is in xlsx format, and locally saved on my One drive. * Any tips & tricks to have the Data managed well & to work on file faster, which currently due to size its too slow. Your help is appreciated. Cheers!

[@mohammedishaq9217]

@Bas @HowtoPowerBI Any tips & tricks to have a work around better on huge data set would be helpful.

[@priyanshugarg9309]

Hey bas, i am working on same kind of problem, one additional requirement is on y axis i need bar chart(values can go upto 1000) and on secondary y axis we have results which can vary from 1 to 100%

[@raeesg]

Very smart!

[@HowtoPowerBI]

🚀😎✌️ thanks for watching

[@tomas2251]

Hey Bas, I'm trying to do this char in my Power BI report and if I add year slicer into page then I lost RowLbl1Pos and RowLbl2Pos label

[@johnkostiw6515]

How does the conditional formatting on axis value colors work - had no success with it, was expecting to work like bar colors 🤷‍♂

[@shraddhahingankar3952]

from where we can download the data set ?

[@HowtoPowerBI]

download link is in the description

[@jim5400]

Not all heroes wear capes

[@zorankrekic3006]

Nice, as all presentation, values belove first month or quarter sholud be empty, we dont have values for compare, maybe in their place put thr information "∆ PM" and "∆% PM"

[@enocharthur4322]

Creating lots of dax measures just to achieve this visual may not be the best way to spend my time when I have a big model with lots of KPIs or measures to visualize

[@garyflagray1092]

Wow ❤

[@wilconagtzaam587]

You must have followed the wizard school of data vizualisation....🤯🤯🤯

[@HowtoPowerBI]

✌️🔥🤣 yes called datatraining 🚀

[@simeontodorov9353]

3:30 how do you put your measures in a subfolder like that?

[@kawaikod]

You can name a folder with a backward slash folder\subfolder

[@MrMaazias]

Love the videos but dislike the clickbait. I'd like to know more about the content of the video based on the title. Keep up the good work!

[@HowtoPowerBI]

I think this option should be there by default, so not so sure what is misleading here

[@eriochrome_bt]

AHHh more bookmarks when DAX should be what drives the hierarchy up/down. but cool hack none the less!

[@paulwyatt8523]

You are not a wizard. You are a freakin' warlock! How on earth can you explain how you came to this solution? So, I decided two things after watching your presentation. Firstly, this is going to be expensive; If client wants it, they pay! Secondly, I need to go to the crossroads cuz I'm swapping my blues skills or I want a refund. On a serious note. Baz. This is astounding. A lot of hard work went into this offering. It is the sort of thing I look for to know I am confident that what is possible in PBI and what is exceptional - and that they are so far apart. It does astound me that Microsoft have not provided this functionality when it is there in EXCEL. And, no, TABLE view does not cut it. My respect for MS stops me from being too upset, and I am paid for what I do with their products so...reality check. Thank you so much for this Bas.

[@AnmolZade-w7w]

Creative

[@HowtoPowerBI]

Thanks!

[@pmo4325]

Bas I don't know which country you are from, but your visuals belong in your national art museum!

[@vishalnasre1251]

with this aren't we messing with actual sales values ? and the Y axis

[@impala4641]

Nice nice nice

[@pulfredy1]

It's a clever technique, but from a professional developer's perspective, it may be challenging to sustain over time.

[@jevonzhu]

pretty tricky skill

[@HowtoPowerBI]

✌️🔥🚀

[@Khan-e-Zaika]

Scenario 1.calendar table 2. Table1 created in m query using some.condition 3. Need to create table2 using dax where date is selected in slicer should produce a table with records from selected date till the max date Eg..List of dates for an year If I select 09/14/2025 it should give table result from 14 sep 2025to 31st dec 2025 and so on I am.facing problem where I am storing the selectedvalue date in a variable it diaplays correctly on the card but when I try to create table using dax it passes it as null Filter condition is loadstartdate>=selectedvalue (date) Note: Table 2 is exact copy of table1 just have filtered rows based on selecteddate till max date

[@cody-9g]

I feel like I want an Adobe / Microsoft merger. If they actually wanted to push out the best product to be #1, I would welcome it minus the impending apocalypse that would happen from a merger of such scale.

[@gudepuramakrishna3532]

Hi could you please help me with this scenario : i have 20 measures of different currency data type based on region slicer selection i have show respective currency measure suppose if i select dubai option from slicer then in y axis will be in arabic currency if US then dollar i created a parameter for all this measures and used that parameter in bar chart now if we wont select any option in slicer then all measures will be seen but without any selection in slicer we need to default US measure dollar in Y axis

[@PranayPawar1991]

Power Bi artists 😅

[@In_a_state]

Very creative solution, but I hate these kind of titles.

[@HowtoPowerBI]

Better suggestion?

[@In_a_state]

@@HowtoPowerBI "Best way to make a combo chart & table in Power BI" or something. What irks me is that the title is just so false, too general, pretty ridiculous.

[@hyperadapted]

@@In_a_state don't hate the player, hate the game

[@HowtoPowerBI]

🤣🫣

[@patrickgaul6223]

It’s surely not that deep …

[@ashaoush]

You so cute, you know that 😅

[@iiiiii-w8h]

Dude! Enough with the abuse of dummy measures and workarounds. It is disgusting and a bad practice. What the hell are you even teaching? Find something else for content.

[@karinamatvejeva3164]

what do you eat to achieve this result? 😂it's brilliant 🔥