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!
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 ..
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.
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?
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.
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"
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!
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?
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.
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...
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 !! )
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
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.
🤯🤯🤯 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.
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!
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%
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
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.
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
@@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.
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.
My report development process for experienced developers 🚀🔥✌️
datatraining.io/powerbidesigntransformation
Incredibly creative to a solution that Microsoft shouldn't need you to have done. Very well done
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!
For dedicated visual designers, this is perfect ❤ No complaints about the title, some people are so petty!
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!
This might be your best work yet to be honest...this is SO clean. So useful. Thank you for posting!
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 ..
Yeah also a good point ✌️🫣
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.
Brilliant, Bas! 👍 This should hold them off a few seconds longer before asking how they can download the data to Excel. 😅
kkkkkkkkk Please... how is it possible... kkkk???
That's quite impressive. Thank you for sharing and making it easy to follow
That’s nuts Bas. You’re definitely some kind of wizard.
This is so creative and useful! Thank you so much!
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
I’ve been thinking of doing something similar for weeks! Awesome timing for this video
That's fantastic. It is like wavering the wand 🤩
🔝 as usually!
Very clever, thanks for sharing.
😎✌️
Absolutely brilliant!!
That is really cool. I think I'm going to attempt this for my meeting next Friday. Keep up the amazing work
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?
Impressive as always!
Top notch creativity.
Crazy stuff... thx for sharing!!
💻🤓
This is really great! Amazing content
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!!
Man, you really think out of the box to create visuals. Thanks to share
Wow! this is great! I will adopt it in my tables / charts. Thanks a lot!
great work! love it
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.
awsome !! thank you for your sharing 👍
Thanks for watching ✌️🔥
Soo cool. You are very creative.
As usual Bas, mind blowing and so interesting. Thanks for always smiling and putting such a good energy on all your videos 😊
Muy buena aportación.
Gracias
✌️thx for watching
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"
That’s superb Bas! Well done sensei!
Thanks Ruslan!!!
Insane creativity
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!
Thanks 😊 I agree, many times obviously needed functionalities are a pain to make possible dummy x dummy
Amazing 👏... thanks for sharing 🎉
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!!
3:30 how do you put your measures in a subfolder like that?
You can name a folder with a backward slash folder\subfolder
You are very intelligent, I hope I be just 50% of you ❤
amazing, that looks so beautiful ❤❤
How does the conditional formatting on axis value colors work - had no success with it, was expecting to work like bar colors 🤷♂
🤯 Mind Blown 🤯 - Thanks for sharing 👍👍
Thanks for watching! 🚀😎
Amazing!
Great work, Bas! It's a beautiful chart, but my goodness what a headache it is to build.
🤣 love the comment
I wish you could put on a 1hr training session for my department.
Drill up and drill down I wanted the most ❤
Thanks Bas you are amazing 🎉
❤️🔥
OMG - never would have guessed how you will do it in a million years - kickass out of the box thinking! ******** amazing!!!
Total gamechanger 🤯 you could do something like this for same month / same day last year?
Thanks a zillions - this is so very huge for my level, but would definitely try it on my work for sure in coming days. ❤❤
Thanks for watching hope you can use it
Impressive trick.
Absolute genius!
✌️😎🤩
Thank you very much. Love you ❤
🤩✌️
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?
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.
Thanks for watching and for the encouragement:)
this is so good :) thanks for also showing the measures :)
Sure! Glad you like ot
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...
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 !! )
Very smart!
🚀😎✌️ thanks for watching
from where we can download the data set ?
download link is in the description
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
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.
you are greAt
🤯🤯🤯 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.
Bas I don't know which country you are from, but your visuals belong in your national art museum!
You must have followed the wizard school of data vizualisation....🤯🤯🤯
✌️🔥🤣 yes called datatraining 🚀
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!
@Bas @HowtoPowerBI
Any tips & tricks to have a work around better on huge data set would be helpful.
Not all heroes wear capes
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!
I think this option should be there by default, so not so sure what is misleading here
Wow ❤
AHHh more bookmarks when DAX should be what drives the hierarchy up/down. but cool hack none the less!
with this aren't we messing with actual sales values ? and the Y axis
Creative
Thanks!
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%
Nice nice nice
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
It's a clever technique, but from a professional developer's perspective, it may be challenging to sustain over time.
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.
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
pretty tricky skill
✌️🔥🚀
Very creative solution, but I hate these kind of titles.
Better suggestion?
@@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.
@@In_a_state don't hate the player, hate the game
🤣🫣
It’s surely not that deep …
Power Bi artists 😅
You so cute, you know that 😅
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.
what do you eat to achieve this result? 😂it's brilliant 🔥