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?
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!
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.
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
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!
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"
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.
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!
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!
For dedicated visual designers, this is perfect ❤ No complaints about the title, some people are so petty!
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 ✌️🫣
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???
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.
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!!
I’ve been thinking of doing something similar for weeks! Awesome timing for this video
That’s nuts Bas. You’re definitely some kind of wizard.
That's quite impressive. Thank you for sharing and making it easy to follow
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?
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
Man, you really think out of the box to create visuals. Thanks to share
This is so creative and useful! Thank you so much!
That's fantastic. It is like wavering the wand 🤩
As usual Bas, mind blowing and so interesting. Thanks for always smiling and putting such a good energy on all your videos 😊
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!!
Wow! this is great! I will adopt it in my tables / charts. Thanks a lot!
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.
I wish you could put on a 1hr training session for my department.
Great work, Bas! It's a beautiful chart, but my goodness what a headache it is to build.
🤣 love the comment
You are very intelligent, I hope I be just 50% of you ❤
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
Total gamechanger 🤯 you could do something like this for same month / same day last year?
This is really great! Amazing content
Drill up and drill down I wanted the most ❤
Thanks Bas you are amazing 🎉
❤️🔥
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?
Crazy stuff... thx for sharing!!
💻🤓
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
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:)
Very clever, 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...
OMG - never would have guessed how you will do it in a million years - kickass out of the box thinking! ******** amazing!!!
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 !! )
Top notch creativity.
Absolutely brilliant!!
Soo cool. You are very creative.
Impressive as always!
That’s superb Bas! Well done sensei!
Thanks Ruslan!!!
awsome !! thank you for your sharing 👍
Thanks for watching ✌️🔥
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
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.
How does the conditional formatting on axis value colors work - had no success with it, was expecting to work like bar colors 🤷♂
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"
from where we can download the data set ?
download link is in the description
Insane creativity
this is so good :) thanks for also showing the measures :)
Sure! Glad you like ot
Amazing 👏... thanks for sharing 🎉
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.
🤯 Mind Blown 🤯 - Thanks for sharing 👍👍
Thanks for watching! 🚀😎
3:30 how do you put your measures in a subfolder like that?
You can name a folder with a backward slash folder\subfolder
Bas I don't know which country you are from, but your visuals belong in your national art museum!
amazing, that looks so beautiful ❤❤
Muy buena aportación.
Gracias
✌️thx for watching
great work! love it
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%
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
🔝 as usually!
Impressive trick.
Thank you very much. Love you ❤
🤩✌️
You must have followed the wizard school of data vizualisation....🤯🤯🤯
✌️🔥🤣 yes called datatraining 🚀
Not all heroes wear capes
Absolute genius!
✌️😎🤩
you are greAt
with this aren't we messing with actual sales values ? and the Y axis
AHHh more bookmarks when DAX should be what drives the hierarchy up/down. but cool hack none the less!
Amazing!
It's a clever technique, but from a professional developer's perspective, it may be challenging to sustain over time.
Very smart!
🚀😎✌️ thanks for watching
what do you eat to achieve this result? 😂it's brilliant 🔥
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
Creative
Thanks!
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
Wow ❤
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 …
pretty tricky skill
✌️🔥🚀
Nice nice nice
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.